Filling a Combo Box with VBA

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

How can I fill a ComboBox with two items, say "X"
and "Y", using VBA?

All help is appreciated
 
Hi,

Add a userform in the VBA Editor called UserForm1
On that userfom add a combo box called ComboBox1
Write this code in the userform:s Initialize event:

Private Sub UserForm_Initialize()

With ComboBox1
.AddItem "X"
.AddItem "Y"
' Set default text.
.Text = "X"
End With

End Sub

Add a module and write this code in the module in order to show the
userform.

Sub TestForm()
UserForm1.Show
End Sub


HTH
/Ulrik

..
 
Ed said:
How can I fill a ComboBox with two items, say "X"
and "Y", using VBA?
Click to expand...

If you want it at the initialization, you need to use the Initialize event:

Private Sub UserForm_Initialize()
ComboBox1.AddItem "X"
ComboBox1.AddItem "Y"
End Sub

But in general: ComboBox1.AddItem "X"

Regards,
 

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

Fill Combo Box 2
How to Pass a Form to a Function - 2007 4
Rotate Fill Effect With Shape in VBA 4
Excel VBA 2007 - Combo Box 6
create dynamic comboboxes 2
Formula in Vba code help 2
display message box in excel(2003) using VBA word(2003) 0
Creating / Adding items to a combo box list 1

Back
Top