Populate a combo box from a worksheet with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate Form Name to Parse for function 1
Combo Box Question 22
How to fill a combo box with choice from another combo box 7
Having trouble with combo boxes. 11
Making a Custom Dialog Box Work (some code included) 3
list box remove item by combobox 4
Combo Boxes getting data from Work Sheet. 4
Send UserForm Data to .DOT Template 2

Back
Top