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?