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?
|
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? |
All times are GMT +1. The time now is 10:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com