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
--
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?
>

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?
> >

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?
> > >

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?
> > > >