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").Se lect

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").Se lect

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" wrote in message
...
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").Se lect

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" wrote in message
...
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").Se lect

Set the style property to

fmStyleDropDownList ( which is a 2)

--
Regards,
Tom Ogilvy

"Tony_VBACoder" wrote in message
...
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" wrote in
message
...
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").Se lect

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" wrote in message
...
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" wrote in
message
...
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").Se lect