| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate a combo box from a worksheet with VBA
I have a user form to enter data into an excel spreadsheet. I have a combo
box which needs to have 10 items in it, previously i have used the following - With cboTrainer .AddItem = "1" .AddItem = "2" .AddItem = "3" .AddItem = "4" .AddItem = "5" Instead of this can i dynamically populate this list from data in my spreadsheet, like this - With cboTrainer .AddItem = Trainers!B2 My syntax is not quite right, can anyone assist me? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populate a combo box from a worksheet with VBA
See Rowsource property in VBA Help. Regards, Shah Shailesh http://in.geocities.com/shahshaileshs/ (Excel Add-ins Page) *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| populate combo box | Excel Discussion (Misc queries) | |||
| Populate a combo box | Excel Discussion (Misc queries) | |||
| Best way to populate worksheet from 2 combo boxes | Excel Worksheet Functions | |||
| Populate a Combo or List Box | Excel Programming | |||
| Populate a combo Box | Excel Worksheet Functions | |||
Linear Mode
