Selection From Two Columns
Aug 8, 2013I have two strings in two cells, both are dynamic values. I need to plot the values of any of the column that changed in the third cell either the two cells change its values.
View 5 Replies
ADVERTISEMENT
Selection Process Finding X From Within 7 Columns
Sep 10, 2009Hi I have a process in which I have to create a selection without bias. There are 9 categories in this selection process. The 1st and 2nd category already have code and they work differently from the rest. For the 3rd through the 8th categories I have to choose one from the 3rd category, then one from the 4th, etc. After the 8th category I start back at the 3rd and go to the 4th, ect. It ends when cell A1 reaches 30%.
Its a little difficult to explain but the process is simple enough to understand once you see it. I have attached an example of the process. I have also started the code and left explanations within the code.
Filter And Sum Data From Selection Columns
Sep 20, 2009I am trying to find the sum value of a range, specified by two variables.
ie. what is the total spend in 2007 for Hong Kong?
I think I have (with the help of Andy Pope) resolved how to distinguish the correct figures which I wish to summate using with the following
Move Range Selection By Two Columns
Nov 19, 2009I have a spreadsheet with data organized into columns in sets of two - the first column is an X value (Pixel number) and the second column is the Y value (pixel density). I'm trying to make a macro that will select the first set of columns, chart it, move the chart to the next sheet, then select the next two columns of data, chart them and move the chart to the next sheet etc. I've gotten as far as having it make the chart and move it, but I can't seem to make it select the next set of columns - I've been trying different things for a couple days now.
Code:
Hide Columns Based On Selection
Aug 30, 2008I have a worksheet that lists the months of the year on row 3 from columns C through N.
What I am trying to do is to be able to select the month I want from a drop down list or combobox and then hide the remaining columns based on the selection. For example if JAN is selected the months FEB through to DEC would be hidden.
Counting Rows/Columns In Selection Target
Sep 12, 2006I have a data set with rows of data, with a header row along the top. I want to sort my rows of data by column when the cell above the appropriate column is pressed. I know this seems cumbersome - but it fits in with the sheet. The sheet is protected, and we only want the user to be able to sort in this fashion. My problem is, with my code, I get an error when you select a range of two of the header cells. The case selection on the target.column gets confused. How can I check to see if it's just one cell? Is there a property of a range that reflects how many rows or columns it contains? I tried the following (marked with the ' )just from picking out of the pop-up list of properties of the Target range in SelectionChange, but obviously it doesn't work. My original code is the un-'-ed code.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
' If Target.Rows = 1 And Target.Columns = 1 Then
If Target.Row = SortRow Then
Select Case Target.Column
Case PriorityColumn
SortData PriorityColumn
Case JobColumn
SortData JobColumn
Case NotesColumn
SortData NotesColumn
Case SupervisorColumn
SortData SupervisorColumn
Case ShutdownColumn
SortData ShutdownColumn............................
Selection Of Dropdown Populates Remaining Columns
Feb 27, 2007I have an excel spreadsheet that has several fields which should be connected. If one of the fields is selected via a drop down, then several other columns should autopopulate with the data in the list set up on another page. What Im trying to figure out is:
1) How do I make it so it does this with every row on the spreadsheet? I've seen code in the formula bar so that it works for one row, but I need it to work regardless of how many rows are added to the sheet...
and
2) Is there VBA code so that if someone selects A value from a drop down list in, say, column F, that data corresponding to that selection is placed in other columns in the sheet?
Prevent Selection On Hidden Rows/Columns
Sep 21, 2007One of the fields I want them to enter is a library branch and I have used a data vaslidation list to provide a dropdown box.
To make it act more like a windows drop down box I have hidden 7 cells above this box with the 7 possible entries. This means that with autocomplete, if they start typing in the cell it will autocomplete the entry for them.
This work fine, but if someone presses enter from the cell above my hidden rows, one of the hiddenn cells is selected!
WHY!
I have no explanation for this behaviour, nothing like it has ever happened before, and I have no idea how to get rid of it.
example attached
Data Validation (Show Two Columns Only Populate One Field Upon Selection)
Jul 2, 2014Basically I have a form where the list can expand and contract so there will always be varying row lengths.
What I would like to see is a drop down list that shows a) the actual populated field and b) a description of the field when the drop down list is present.
I believe this can be done with a combo box however that would be a lot of work.
Variable Column Range Based On Current Selection For Sorting Columns
May 16, 2014The first line of the code chooses the columns to select; all columns until there is no value. From there I need to have it sort those columns based on row 1. The problem is that the columns chosen are variable. It could be columns I:N (as shown below) or column G:Z or any other combination. (The code below was recorded if that matters at all.)
View 2 Replies View RelatedDisplaying Input Box Based On User Selection Of Dropdown Selection?
Jun 3, 2013If a user selects certain options from a drop down list created by cell verification (from list), is it possible to display an input box and have the resulting input populate on another worksheet in the workbook? I have an attendance template I'm working with and if a user selects OT (Over Time) then a input box is displayed prompting for how many hours. The overtime is then tracked on another worksheet.
View 1 Replies View RelatedIncrement Cell On Selection And Lock/Protect From Re-Selection
Oct 3, 2006I tried very hard to design a leave roster for user to mark their leave application. The criteria are as follows:
1. 4 applications per date
2. a region of worksheet (i.e. "A2 to H20) will be defined for users to "click" on the cells (within the defined region) to mark their application.
3. once a cell is clicked (i.e. marked), it cannot be altered.
4. each click will automatically increase the total by 1.
I got the following code to deal with the situation but user can still click on any cell outside the region (in fact I fail to define the region).
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim m
ad = Mid(ActiveCell.Address, 2, 1)
m = Range(ad & 24).Value 'here a formula "CountA(A2,A20)" will be place in the cell (24, c).......................
Copy & Paste Selection Based On Combo Box Selection
Jan 30, 2007I have attached a portion of an excel file I am using at the moment. What I require is a piece of VBA code which will allow me to copy selected data based on a combo box selection. What needs to happen is this :-
If the selection in the "Index" worksheet combo box related to "Month" in cell G19 is for instance "December", I would like the macro to compare this cell value to the cell values in cells C96, C124, C152, C180, C209, C236, C263 and C290 in the "Tech Services" worksheet and where the values match.......copy the commentary (Range C126:Z147 in December's case) to the range C34:Z55.
Disable Selection In Listbox On Selection Of Item
Apr 4, 2013I am working on a project where user has to select an item from a listbox, however there is a condition that if user select an item, other items of listbox should be disabled so that he/she can not select any other item.
Is there any way to do that as I tried
VB : Listbox.enabled = False
and
VB : Listbox.locket = True
in Listbox - Click/Change but no desirable results got.
Restrict Drop-Down Selection Based On Selection From Another
Jul 20, 2007I want to have a drop down list in a cell so that the value in the cell can be only selected from two columns of data. Additionally once the data from the first column has been selected I want to be able to limit the inputs the user can select from in the second column.
e.g. In cell C115 I want to have the value BDS05.
I want to be able to select the value BDS from a drop down list of values and once that value has been selected I want to be able select 05 from a list of values from 01 to 14
If I select BCS as the first value then I want the second set of values to be limited to 01 to 02 etc.
I have read about combo boxes and list boxes and I'm a bit confused about the best way to achieve this (or even if I can).
Run Selection Change Event Only If The Row Selection Changes
Mar 26, 2007I'm using the following code in a worksheet:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
col = ActiveCell.Column
Range("output") = ActiveCell.Offset(0, -(col - 4)).Value
End Sub
In case it's not obvious, the macro places the value in the active row and 4th column of the worksheet into the range "output".
The problem is, the worksheet is large and somewhat slow to recalculate. This macro forces a recalc on any selection change, but i only need it to run when the row selection changes, not the column.
I'm sure there's a straightforward way to reprogram this.
Investment Selection With Cell Selection
May 4, 2007I'm trying to build an investment calculator. Tried searching "calculator" as keyword but return nothing similiar.
There are eight cell : [ A ][ B ][ C ][ D ][ E ][ F ][ G ][h]
[ H ] is price of the leverage
[A] is X balance
[b] is X lot size
[C] is X amount of money use to get x lot
[D] is X percentage of money use to get x lot
[E] is X point gain
[f] is X money gain
[G] is balance + money gain
Ignore the formulae for leverage to determine 1 lot price. Take 1 lot = 250.
What I'm looking for is when I enter any value at cell B, C or D, it will automatically calculate the value for either B, C or D cell.
Let say, the balance is 10000.
If I enter 2 at cell B. Then, it will calculate the value for cell C & D.
If I enter 750 at cell C, then it will calculate value for cell B & D.
If I enter 25 at cell D, it will calculate value for cell B & C.
how to use OR Selection in excel.
If Selection Or Any Part Of The Selection
May 24, 2007If the selection (or any part of the selection) = bla bla bla
VBA - Selection Box
Jul 13, 2007I have a code (pasted below) that copys a line of data from one workbook into another. Each time i run the code it enters the data on the next available line. This is all working ok however what I would really like to do is when i run the code have it pop up a selection box asking me which sheet i would like to copy from. The reason i need this is that the sheet that gives the data isn't always named the same although the format is exactly the same every time. In this example the data sheet is "copy of NewProductForm), this name may change and i may also have other different active workbooks open at the same time and I don't want the macro to get data from them.
Code :
Sub GetData()
Windows("Copy of NewProductForm.xls").Activate
Rows("48:48").Select
Selection.Copy
Windows("Book2.xls").Activate
NextRow = Range("A65536").End(xlUp).Row + 1
Range("A" & NextRow).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("Copy of NewProductForm.xls").Activate
Application.CutCopyMode = False
Range("A41:AH41").Select
Windows("Book2.xls").Activate
End Sub
First & Last Row Of Selection
Dec 22, 2006I am trying to format a range of cells based on a user selection. The user may select 8 rows (rows 20 - 27) or the might just select A20 to A27 or the may select A20 to C27 on all of the occasions I would like to find the 1st row and the last row of a selection. I have found the command
x = ActiveWindow.RangeSelection.Address
which I could try and extract the row numbers, but is there an easier way?
Min Row And Max Row Of A Selection
Jan 24, 2007I want to program a macro that reads out the min row number and max row number of a selection.
Lets say a user selected the Range A1:D4.
After executing the macro I want the following output:
The min row number of the selection is: 1
The max row number of the selction is: 4
Move Selection One To The Right?
Mar 18, 2014For a specific equation to work I need to know the distance whenever the acceleration is maximum.
The last part is a piece of cake, using MAX I get the desired results.
However, returning the distance is difficult.
What I'd like to do is return the value of the cell to the right of the maximum acceleration.
Using
=ADDRESS(MATCH(MAX(K2:K754);K2:K754;0);COLUMN(K2:K754))
I got the address of MAX, but that's about as far as I get.
Sum Only Value Of List Selection?
Jul 17, 2009I have a list of 4 customers and their individual revenue, which is summed up in cell E12.
What needs to be done to make Excel only sum revenue of say customer A and D in cell 12 upon selection of these through standard filter (see attached sample)?
How To Print A Selection To PDF
Apr 9, 2013I've attached a sheet. In this sheet I would like to print the selection....C9:17 and BL9:BW17. I would like to print it onto a PDF and I would like to expand it so it is very visible. Actually, it doesn't need to be PDF. If I could just print this selection and make it visible that would work. I had a problem using print selection because the columns are separated. I also tried fit to page but that makes it too small.Mod's note: file attachment removed at OP's request
View 2 Replies View RelatedSumming With #DIV/0 In Selection
Oct 22, 2008I'm having a problem summing after running arrays to analyse data. I have a list of four possible outcomes and I need sum up the totals, but sometimes there are no results, so there is #DIV/0 in the list I need to find the total for.
is there some code or some kind of formatting that would give me a total even if #DIV/0 is in the list?
Testing A Selection
Nov 2, 2008I've currently written the following code to make sure exactly 2 single cell selections are made. But now, I want to extend this code to make sure only cells from rows 5 & 7 are selected and the cells are in the same column.
View 2 Replies View RelatedUsing Trim On A Selection
Dec 18, 2008I want to create a macro that will allow me to highlight a column and have the macro Trim every cell with text in the column, preferably putting the results over the original text. The column in question has text in every cell, until the column ends.
(That is, there are no numbers and no blanks until the data ends altogether.) I do not want to remove internal spaces in the text, just the leading and trailing ones.
I am sure this is fairly simple, but I'm not sure how to get it to look at every cell and then terminate properly.
Not Allow Cell Selection ...
Jun 16, 2009It is actually a form - much like Access. I have protected it so it can't be changed. They can click on a particular cell, but as soon as they try to enter anything it gives them a message and entry is not allowed.
Is it possible to even prevent them from selecting an individual cell, i.e., restricting them to only clicking the control buttons ? I realize this is a spreadsheet, other products would probably have worked better, etc., however it's kind of like the last minor hurdle before releasing it for general use. The world certainly will not stop if I can't - just thought I would check with the expers.
About Range Selection
Jul 22, 2009A question regarding "AboutRangeSelection" procedure on Chapter 11 in the **, Excel 2003 Power Programming with VBA by John Walkenbach.
View 3 Replies View RelatedCheck If Selection Changes To Anywhere Row 1
Jan 31, 2012This works...
If Not Intersect(Target, Range("E1")) Is Nothing Then
However..
How do I change Range("E1") to any cell on row 1?