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?

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?

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?

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?

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?