How to Activate and Dropdown a Combo Box

[PosseJohn]

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?

 

[Alan Moseley]

Lets say that your ComboBox name is MyCombo. You need to include the code:-

MyCombo.DropDown
MyCombo.Activate

 

[PosseJohn]

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]

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?

 

[PosseJohn]

No, that didn't prevent occurence.

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.