Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combo box
Hi: I have a combobox which shows two values: name and age, after I
choose "the value", the combo box just shows the "name". I need to be able to print both values. How can I tell the combo box to leave the 2 fields onscreen? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combo box
Hello Gabito,
You can only display one column in the Combo Box. Is this Combo Box on a worksheet? If so, the TextColumn is the one that is displayed and the BoundColumn is the value returned by the combo box. You could make the TextColumn 1 (Name) and the BoundColumn 2 (Age). Then set the Linked cell to an adjacent cell just to the right of the Combo Box. That way the Name (Column1) can be displayed in the Combo Box and the Age (Column 2) in the adjacent linked cell. If it is on a userform then get back to me if and I'll explain how to achieve it in a text box on a user form. -- Regards, OssieMac "Gabito" wrote: Hi: I have a combobox which shows two values: name and age, after I choose "the value", the combo box just shows the "name". I need to be able to print both values. How can I tell the combo box to leave the 2 fields onscreen? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
In Excel I need to set up a combo box based on another combo box. | 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) |