Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling multiple cells based on 1 combo box selection
I've created a combo box with 4 columns,
Column 1 is the only visible colum on the drop down list. I have bound column 2 to cell A2 on my worksheet. Is it possible to bind the remaining 2 columns to separate cells in the worksheet. For example I would like to have colum 2 bound to A2, column 3 bound to B2, Column 4 bound to cell C2. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling multiple cells based on 1 combo box selection
No, the boundcolumn determines the value of the combobox - thus only one
boundcolumn is possible. You would need code to populate the other cells (or all cells). Use the Click event as an example. Another possibility is to use Vlookup to fill in the other cells (if your source data is on the worksheet someplace). -- Regards, Tom Ogilvy Serrena Carter wrote in message ... I've created a combo box with 4 columns, Column 1 is the only visible colum on the drop down list. I have bound column 2 to cell A2 on my worksheet. Is it possible to bind the remaining 2 columns to separate cells in the worksheet. For example I would like to have colum 2 bound to A2, column 3 bound to B2, Column 4 bound to cell C2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically filling a cell from a worksheet based on a selection | Excel Worksheet Functions | |||
Conditional Formating Based on Selection in a Combo Box | Excel Discussion (Misc queries) | |||
Multiple Selection Combo Box | Excel Discussion (Misc queries) | |||
Multiple selection on a combo box | Excel Worksheet Functions | |||
multiple selection in combo box | Excel Discussion (Misc queries) |