command button to combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hoysala - 18 Mar 2008 20:34 GMT

dear all

i have number of commnad buttton in embedded in a sheet

i want to shift to a combobox

please guide me

Reply to this Message

Office_Novice - 18 Mar 2008 21:09 GMT

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

> dear all
>
[quoted text clipped - 3 lines]
>
> please guide me

Reply to this Message