I need to built Combo box in which I can choose from down list menu. could
you advise step by step how I can do it.

Have you tried looking in Help?

--

Vasant

"Friends2005" wrote in message
...
I need to built Combo box in which I can choose from down list menu. could
you advise step by step how I can do it.

Yes I tried.
I know how I add combo box, but my question how I can put items in this box
in order to use it as (pick up from down list)

regards,

"Vasant Nanavati" wrote:

Have you tried looking in Help?

--

Vasant

"Friends2005" wrote in message
...
I need to built Combo box in which I can choose from down list menu. could
you advise step by step how I can do it.

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

Thanx a lot

"mangesh_yadav" wrote:


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