How to Activate and Dropdown a Combo Box

  • Thread starter Thread starter PosseJohn
  • Start date Start date
P

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?
 
Lets say that your ComboBox name is MyCombo. You need to include the code:-

MyCombo.DropDown
MyCombo.Activate
 
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?
 
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?
 
No, that didn't prevent occurence.

Alan Moseley said:
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.
Click to expand...
 
Back
Top