Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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").Se lect |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets("Brackets").DropDowns("Game10").Click
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets("Brackets").DropDowns("Game10").Click
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets("Brackets").DropDowns("Game10").Click
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets("Brackets").DropDowns("Game10").Click
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets("Brackets").DropDowns("Game10").Click
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |