Can a Combobox list be Dropped Open displaying the list of values when a
userform is Activated.
I want to Fool-Proof Prompt the user to select this value 1st.

Can this be done?
How?

Sub userform_Activate()
combobox92.dropdownlist=activate ' ???
end sub


Corey....

Never mind.
Solved it just as i posted.

ComboBox92.DropDown

Funny thing is though:
The Values are NOT displayed IN the Combobox, they are Displayed In the
Centre of the Userform.
NO problems for me though, just means the User would have to TRIP OVER the
values to miss them.

Corey....

"Corey" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Can a Combobox list be Dropped Open displaying the list of values when a
> userform is Activated.
> I want to Fool-Proof Prompt the user to select this value 1st.
>
> Can this be done?
> How?
>
> Sub userform_Activate()
> combobox92.dropdownlist=activate ' ???
> end sub
>
>
> Corey....
>

Corey,
Using .DropDown in the Userform_Initailize event, I get strange behaviour;
the list portion appears outside of the form.
In the _activate event, it works fine.

NickHK

"Corey" <(E-Mail Removed)> wrote in message
news:um8$(E-Mail Removed)...
> Never mind.
> Solved it just as i posted.
>
> ComboBox92.DropDown
>
> Funny thing is though:
> The Values are NOT displayed IN the Combobox, they are Displayed In the
> Centre of the Userform.
> NO problems for me though, just means the User would have to TRIP OVER the
> values to miss them.
>
> Corey....
>
> "Corey" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Can a Combobox list be Dropped Open displaying the list of values when a
> > userform is Activated.
> > I want to Fool-Proof Prompt the user to select this value 1st.
> >
> > Can this be done?
> > How?
> >
> > Sub userform_Activate()
> > combobox92.dropdownlist=activate ' ???
> > end sub
> >
> >
> > Corey....
> >
>
>