3 ways to add items, assuming you have selected the combobox from the
control toolbox:
1.
Enter the following code in the sheet module
Private Sub Worksheet_Activate()
ComboBox1.ListFillRange = "Sheet1!A1:J10"
End Sub
Or
2. Right-click on the combo and view properties. In the listfillrange,
enter the source of the list
or
3.
Enter the following code in the sheet module
Private Sub Worksheet_Activate()
ComboBox1.AddItem "item1"
ComboBox1.AddItem "item2"
' and so on
End Sub
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=378526