| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox
i have the following code.
ActiveSheet.ComboBox2.Clear ActiveSheet.ComboBox2.AddItem "Enter Quantity" ActiveSheet.ComboBox2.ListIndex = 0 ComboBox2.Visible = True I would like the "Enter Quantity" to be highlighted, so a number can be entered without using the mouse. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combobox
I would do it this way:
With ActiveSheet.ComboBox2 .Clear .AddItem "Enter Quantity" .ListIndex = 0 .Visible = True .Activate End With "sunilpatel" wrote: i have the following code. ActiveSheet.ComboBox2.Clear ActiveSheet.ComboBox2.AddItem "Enter Quantity" ActiveSheet.ComboBox2.ListIndex = 0 ComboBox2.Visible = True I would like the "Enter Quantity" to be highlighted, so a number can be entered without using the mouse. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combobox
i have tried this but the selected item is not highlighted. Please help
"JLGWhiz" wrote in message ... I would do it this way: With ActiveSheet.ComboBox2 .Clear .AddItem "Enter Quantity" .ListIndex = 0 .Visible = True .Activate End With "sunilpatel" wrote: i have the following code. ActiveSheet.ComboBox2.Clear ActiveSheet.ComboBox2.AddItem "Enter Quantity" ActiveSheet.ComboBox2.ListIndex = 0 ComboBox2.Visible = True I would like the "Enter Quantity" to be highlighted, so a number can be entered without using the mouse. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| Combobox items determined by the selection in another combobox | Excel Programming | |||
| Combobox options based on the input of another combobox | Excel Programming | |||
| ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
| How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Linear Mode
