Worksheets("Brackets").DropDowns("Game10").Click

With Excel 2000, I have added a combo box control to my worksheet and named
it "myCombo1". In this combo box, there are 5 items. How do I use VBA to
select this combo box and automatically have it drop down using VBA? In
Microsoft Access I would use the "Dropdown" method of my combo box. However,
in Excel, I have not been able to find an equivalent. I have done the
following to select my combo box, but can't find a Dropdown method:

Worksheets("myWorksheet").DropDowns("myCombo1").Select

Oops...the subject line should have read "Combo Box DropDown method". I
clicked the Post button before I changed the subject. Is there a way I can
get this subject line changed?

"Tony_VBACoder" wrote:

> With Excel 2000, I have added a combo box control to my worksheet and named
> it "myCombo1". In this combo box, there are 5 items. How do I use VBA to
> select this combo box and automatically have it drop down using VBA? In
> Microsoft Access I would use the "Dropdown" method of my combo box. However,
> in Excel, I have not been able to find an equivalent. I have done the
> following to select my combo box, but can't find a Dropdown method:
>
> Worksheets("myWorksheet").DropDowns("myCombo1").Select

I wouldn't worry about the Subject.

Use a combobox from the Control Toolbox Toolbar rather than the forms
toolbar. This Contro Toolbox Toolbar Combobox has a dropdown method.

--
Regards,
Tom Ogilvy

"Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in message
news:6D8D776D-77C2-4655-BEDB-33A3920FC87E@microsoft.com...
> Oops...the subject line should have read "Combo Box DropDown method". I
> clicked the Post button before I changed the subject. Is there a way I
can
> get this subject line changed?
>
> "Tony_VBACoder" wrote:
>
> > With Excel 2000, I have added a combo box control to my worksheet and
named
> > it "myCombo1". In this combo box, there are 5 items. How do I use VBA
to
> > select this combo box and automatically have it drop down using VBA? In
> > Microsoft Access I would use the "Dropdown" method of my combo box.
However,
> > in Excel, I have not been able to find an equivalent. I have done the
> > following to select my combo box, but can't find a Dropdown method:
> >
> > Worksheets("myWorksheet").DropDowns("myCombo1").Select

Tom, to do this, I had to change all my combo boxes from using Forms toolbox
to the Control Toolbox. Now that I have changed all my combo boxes to the
Control Toolbox combo box, I need to know how I can prevent a user from
typing in the combo box. What property prevents them from doing this? I
have the "ListFillRange" property set to the range in my worksheet that I
want to populate my combo box, but when the user clicks on the combo box,
they can type in the combo box, which is not what I want to happen.

"Tom Ogilvy" wrote:

> I wouldn't worry about the Subject.
>
> Use a combobox from the Control Toolbox Toolbar rather than the forms
> toolbar. This Contro Toolbox Toolbar Combobox has a dropdown method.
>
> --
> Regards,
> Tom Ogilvy
>
> "Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in message
> news:6D8D776D-77C2-4655-BEDB-33A3920FC87E@microsoft.com...
> > Oops...the subject line should have read "Combo Box DropDown method". I
> > clicked the Post button before I changed the subject. Is there a way I
> can
> > get this subject line changed?
> >
> > "Tony_VBACoder" wrote:
> >
> > > With Excel 2000, I have added a combo box control to my worksheet and
> named
> > > it "myCombo1". In this combo box, there are 5 items. How do I use VBA
> to
> > > select this combo box and automatically have it drop down using VBA? In
> > > Microsoft Access I would use the "Dropdown" method of my combo box.
> However,
> > > in Excel, I have not been able to find an equivalent. I have done the
> > > following to select my combo box, but can't find a Dropdown method:
> > >
> > > Worksheets("myWorksheet").DropDowns("myCombo1").Select
>
>
>

Set the style property to

fmStyleDropDownList ( which is a 2)

--
Regards,
Tom Ogilvy

"Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in message
news:6C953EB6-946B-4085-93B7-62D43B9071B0@microsoft.com...
> Tom, to do this, I had to change all my combo boxes from using Forms
toolbox
> to the Control Toolbox. Now that I have changed all my combo boxes to the
> Control Toolbox combo box, I need to know how I can prevent a user from
> typing in the combo box. What property prevents them from doing this? I
> have the "ListFillRange" property set to the range in my worksheet that I
> want to populate my combo box, but when the user clicks on the combo box,
> they can type in the combo box, which is not what I want to happen.
>
> "Tom Ogilvy" wrote:
>
> > I wouldn't worry about the Subject.
> >
> > Use a combobox from the Control Toolbox Toolbar rather than the forms
> > toolbar. This Contro Toolbox Toolbar Combobox has a dropdown method.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in
message
> > news:6D8D776D-77C2-4655-BEDB-33A3920FC87E@microsoft.com...
> > > Oops...the subject line should have read "Combo Box DropDown method".
I
> > > clicked the Post button before I changed the subject. Is there a way
I
> > can
> > > get this subject line changed?
> > >
> > > "Tony_VBACoder" wrote:
> > >
> > > > With Excel 2000, I have added a combo box control to my worksheet
and
> > named
> > > > it "myCombo1". In this combo box, there are 5 items. How do I use
VBA
> > to
> > > > select this combo box and automatically have it drop down using VBA?
In
> > > > Microsoft Access I would use the "Dropdown" method of my combo box.
> > However,
> > > > in Excel, I have not been able to find an equivalent. I have done
the
> > > > following to select my combo box, but can't find a Dropdown method:
> > > >
> > > > Worksheets("myWorksheet").DropDowns("myCombo1").Select
> >
> >
> >

Tom, thank you...that did the trick.

One other question. When I changed all my combo boxes (65 of them) from the
Form combo boxes to the comb boxes in the Controls Toolbox, I noticed my
spreadsheet went from 600K to just under 1MB. Why the increase in size?

"Tom Ogilvy" wrote:

> Set the style property to
>
> fmStyleDropDownList ( which is a 2)
>
> --
> Regards,
> Tom Ogilvy
>
> "Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in message
> news:6C953EB6-946B-4085-93B7-62D43B9071B0@microsoft.com...
> > Tom, to do this, I had to change all my combo boxes from using Forms
> toolbox
> > to the Control Toolbox. Now that I have changed all my combo boxes to the
> > Control Toolbox combo box, I need to know how I can prevent a user from
> > typing in the combo box. What property prevents them from doing this? I
> > have the "ListFillRange" property set to the range in my worksheet that I
> > want to populate my combo box, but when the user clicks on the combo box,
> > they can type in the combo box, which is not what I want to happen.
> >
> > "Tom Ogilvy" wrote:
> >
> > > I wouldn't worry about the Subject.
> > >
> > > Use a combobox from the Control Toolbox Toolbar rather than the forms
> > > toolbar. This Contro Toolbox Toolbar Combobox has a dropdown method.
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in
> message
> > > news:6D8D776D-77C2-4655-BEDB-33A3920FC87E@microsoft.com...
> > > > Oops...the subject line should have read "Combo Box DropDown method".
> I
> > > > clicked the Post button before I changed the subject. Is there a way
> I
> > > can
> > > > get this subject line changed?
> > > >
> > > > "Tony_VBACoder" wrote:
> > > >
> > > > > With Excel 2000, I have added a combo box control to my worksheet
> and
> > > named
> > > > > it "myCombo1". In this combo box, there are 5 items. How do I use
> VBA
> > > to
> > > > > select this combo box and automatically have it drop down using VBA?
> In
> > > > > Microsoft Access I would use the "Dropdown" method of my combo box.
> > > However,
> > > > > in Excel, I have not been able to find an equivalent. I have done
> the
> > > > > following to select my combo box, but can't find a Dropdown method:
> > > > >
> > > > > Worksheets("myWorksheet").DropDowns("myCombo1").Select
> > >
> > >
> > >
>
>
>