| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Activate and Dropdown a Combo Box
I have a sheet with 2 dropdown combo boxes. Each box overlays on the output
cell for the combo box. I have a Worksheet_SelectionChange event that detects when either output cell is selected by the user. How do I activate the Combo Box and dropdown its list? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Activate and Dropdown a Combo Box
Lets say that your ComboBox name is MyCombo. You need to include the code:-
MyCombo.DropDown MyCombo.Activate -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "PosseJohn" wrote: I have a sheet with 2 dropdown combo boxes. Each box overlays on the output cell for the combo box. I have a Worksheet_SelectionChange event that detects when either output cell is selected by the user. How do I activate the Combo Box and dropdown its list? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Activate and Dropdown a Combo Box
That somewhat worked...something strange occurs when the code runs.
It presents the dropdown list at the top of the worksheet window and not below where the combo box resides. Do I need to lockdown the combo box somehow? "Alan Moseley" wrote: Lets say that your ComboBox name is MyCombo. You need to include the code:- MyCombo.DropDown MyCombo.Activate -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "PosseJohn" wrote: I have a sheet with 2 dropdown combo boxes. Each box overlays on the output cell for the combo box. I have a Worksheet_SelectionChange event that detects when either output cell is selected by the user. How do I activate the Combo Box and dropdown its list? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Activate and Dropdown a Combo Box
In design mode right-click your combo and choose format control. Click on
the properties tab. Select Dont move or size with cells. Does this help? -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "PosseJohn" wrote: That somewhat worked...something strange occurs when the code runs. It presents the dropdown list at the top of the worksheet window and not below where the combo box resides. Do I need to lockdown the combo box somehow? "Alan Moseley" wrote: Lets say that your ComboBox name is MyCombo. You need to include the code:- MyCombo.DropDown MyCombo.Activate -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "PosseJohn" wrote: I have a sheet with 2 dropdown combo boxes. Each box overlays on the output cell for the combo box. I have a Worksheet_SelectionChange event that detects when either output cell is selected by the user. How do I activate the Combo Box and dropdown its list? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Activate and Dropdown a Combo Box
No, that didn't prevent occurence.
"Alan Moseley" wrote: In design mode right-click your combo and choose format control. Click on the properties tab. Select Dont move or size with cells. Does this help? -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "PosseJohn" wrote: That somewhat worked...something strange occurs when the code runs. It presents the dropdown list at the top of the worksheet window and not below where the combo box resides. Do I need to lockdown the combo box somehow? "Alan Moseley" wrote: Lets say that your ComboBox name is MyCombo. You need to include the code:- MyCombo.DropDown MyCombo.Activate -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "PosseJohn" wrote: I have a sheet with 2 dropdown combo boxes. Each box overlays on the output cell for the combo box. I have a Worksheet_SelectionChange event that detects when either output cell is selected by the user. How do I activate the Combo Box and dropdown its list? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combo Box / Dropdown Box HELP!!!! | Excel Discussion (Misc queries) | |||
| what is code to activate a combo box in control toolbox | Excel Discussion (Misc queries) | |||
| Can a combo box activate different macros | Excel Discussion (Misc queries) | |||
| Dynamically Activate a Combo Box | Excel Programming | |||
| dropdown list to activate Macro | Excel Programming | |||
Hybrid Mode
