combo box
in [Functions]
|
Prev: Trying to convert mm/yy in text to Dec-07, it adds day & current y
Next: Last number in a column shows in the total/summay line cell
From: Gabito on 22 Mar 2010 19:38 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?
From: OssieMac on 23 Mar 2010 03:46
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? > . > |