How I can built combo box step by step
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 |
All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com