Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to insert a list in the ActiveX combo box
I have inserted ActiveX combo boxes into a form, but cannot figure out how to
insert the list of choices that will appear when I click the drop down. I am using Excel 2000. Does anyone know how to do this? I can create form's drop down lists and another form of drop down off the tool bar, but I understand that if I want this data to be communicated with a database I need to use the ActiveX control. -- Carl Snider |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to insert a list in the ActiveX combo box
With the control shown and in design mode, click the [Properties] icon on the
Control Toolbox. Look for ListFillRange - that's where you tell it where to get the list it displays. The LinkedCell property is where the choice made into it can be set to be echoed on a worksheet for easier determination of what was chosen. "Carl Snider" wrote: I have inserted ActiveX combo boxes into a form, but cannot figure out how to insert the list of choices that will appear when I click the drop down. I am using Excel 2000. Does anyone know how to do this? I can create form's drop down lists and another form of drop down off the tool bar, but I understand that if I want this data to be communicated with a database I need to use the ActiveX control. -- Carl Snider |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box List in another workbook | Excel Discussion (Misc queries) | |||
Combo box list w/ data in 2nd workbook without opening both files | Excel Worksheet Functions | |||
List, Combo Box, Data Validation?? | Excel Discussion (Misc queries) | |||
How do I find data from a list (or table) and insert it in a row? | Excel Discussion (Misc queries) | |||
Combo box list depends on value | Excel Discussion (Misc queries) |