Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combo box for 97
I am having a difficult time trying to find out how you put a combo box in
using excel 97. I also want the box attached to a cell. I'm a novice at excel. Thanks, Tia |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combo box for 97
Hi,
The easiest way is to choose View, Toolbars, Forms. Then click the combo box tool and click or drag in the spreadsheet. To attach its results to a cell, right-click it choose Format Control, click the Control tab and set a link cell (where you want the results) and Input range (where you list the items you want displayed in the combo box) If this helps, please click the Yes button cheers, Shane Devenshire "Tia" wrote: I am having a difficult time trying to find out how you put a combo box in using excel 97. I also want the box attached to a cell. I'm a novice at excel. Thanks, Tia |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combo box for 97
I want it to act exactly like a drop down box (data validation) but I also
want to be able to type in the box if I can't find it in my drop down menu. "Shane Devenshire" wrote: Hi, The easiest way is to choose View, Toolbars, Forms. Then click the combo box tool and click or drag in the spreadsheet. To attach its results to a cell, right-click it choose Format Control, click the Control tab and set a link cell (where you want the results) and Input range (where you list the items you want displayed in the combo box) If this helps, please click the Yes button cheers, Shane Devenshire "Tia" wrote: I am having a difficult time trying to find out how you put a combo box in using excel 97. I also want the box attached to a cell. I'm a novice at excel. Thanks, Tia |
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) |