| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting info from a combo box
I have a number of combo boxes within my Excel sheet. However, from other
cells I want to be able to get the values of those boxes. The box name is cboList1. For example - for a VLOOKUP command. Can this be done? Many thanks -- Steve R |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
getting info from a combo box
Link the combobox to a cell and use that cell value.
If it is a controls combo, set the LinkedCell property to the cell. If it is a Forms combo, set the Cell Link on the Control tab from the Format Control menu option -- HTH RP (remove nothere from the email address if mailing direct) "Steve" wrote in message ... I have a number of combo boxes within my Excel sheet. However, from other cells I want to be able to get the values of those boxes. The box name is cboList1. For example - for a VLOOKUP command. Can this be done? Many thanks -- Steve R |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
| Using Drop Downs Or Combo Boxes to Look up and display Info | Excel Discussion (Misc queries) | |||
| I need my combo box to return info in a requested cell | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Hybrid Mode
