| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Combo Box | Excel Worksheet Functions | |||
| connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
| extract data from combo box n use it in SQL | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
| dynamic combo boxes | Excel Worksheet Functions | |||
Threaded Mode
