add option to drop down menu

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

Guest

I currently have a drop down menu/combo box in excel and I would like to add
more selections to the drop down menu. Appreciate any hep
 
Try this

Private Sub ComboBox1_GotFocus()
ComboBox1.Clear
ComboBox1.AddItem "Item 1"
ComboBox1.AddItem "Item 2"
ComboBox1.AddItem "Item 3"
End Sub
 
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

Multi layered drop down 1
How to make items in a drop down menu reference a number 2
Select drop down menu option using libre-calc macro 0
Drop Down Menu 4
Drop down menu 3
Copying a Drop Down Menu 2
Drop Down choice needs to lead to another drop down menu 1
how to write a dependent validation with all numbers 1

Back
Top