command button to combo box
 

dear all

i have number of commnad buttton in embedded in a sheet

i want to shift to a combobox

please guide me

command button to combo box
 

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





"hoysala" wrote:

dear all

i have number of commnad buttton in embedded in a sheet

i want to shift to a combobox

please guide me