Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Inside a Form
I want to have a combo box inside a form. This is different from just having a combo box in excel that is linked to a certain range for it's values (ListFillRange in properties of ComboBox). How do I tell a combo box inside of a form what the ListFillRange is?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Inside a Form
set the RowSpource property to something like this:-
sheet2!B3:B5 an alternative could be using code in the form's initialise event, like this... for rw = 1 to 10 combobox1.AddItem mysheet.cells(rw,2) next -- Patrick Molloy Microsoft Excel MVP ---------------------------------- "Joe B." wrote in message ... I want to have a combo box inside a form. This is different from just having a combo box in excel that is linked to a certain range for it's values (ListFillRange in properties of ComboBox). How do I tell a combo box inside of a form what the ListFillRange is? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combo box - VBA form | Excel Discussion (Misc queries) | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo boxes on a form | Excel Discussion (Misc queries) | |||
Using a combo box in an Excel form | Excel Discussion (Misc queries) | |||
Form Combo Box | Excel Discussion (Misc queries) |