command button to combo box

  • Thread starter Thread starter hoysala
  • Start date Start date
H

hoysala

dear all

i have number of commnad buttton in embedded in a sheet

i want to shift to a combobox

please guide me
 
Select a Combo Box from the Tool box tool bar.
Right click the combobox you have imbedded
view code

Private Sub ComboBox1_Change()
ComboBox1.additem "Your First Item"
ComboBox1.Additem "Your Second Item"
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

combo box 2
Searcing for an Excel event. 1
List of Excel DDE commands 1
Menus using VBA? 4
Save data from Notebook: copying to the USB stick using Linux and the command line 0
ActiveX Control Combo Box 9
Populate Combo Box 6
Command Button to start import 3

Back
Top