If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking to combo box selection
In workbook "A" the user will type lots or data into various pre-defined cells. They will also use a couple of combo boxes to make selections.
In another workbook "B" I link to the cells in "A" to summarise but also need to link what was selected in the combo boxes. Pulling data from a cell is obviously very easy but I cannot figure how to get the combo box info. |
#2
|
|||
|
|||
Linking to combo box selection
Hi,
Let's say that the source range for the combo box is in range A1:A4. Right cluck on the combo box and provide the range A1:A4. In the cell link box, provide the reference of any blank cell (say A14). Now in the other workbook, use the match function =match(A14,A1:A4,0) Please change t he formula to include workbook and worksheet names -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "PSM" wrote in message ... In workbook "A" the user will type lots or data into various pre-defined cells. They will also use a couple of combo boxes to make selections. In another workbook "B" I link to the cells in "A" to summarise but also need to link what was selected in the combo boxes. Pulling data from a cell is obviously very easy but I cannot figure how to get the combo box info. -- PSM |
Thread Tools | |
Display Modes | |
|
|