Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am totally stumped by this. I am trying to create a combo box that when I
click on it, it will show me a lfrop down list of "A", "B", "c" AND "D" for me to pick one. I cannot even seem to get started the drop down list keeps coming up blank? Hope someone can help me. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
or is the combo box on a userform? in which case you'll need to add code like this to the form's initalization event userform1.combobox1.additem "A" userform1.combobox1.additem "B" userform1.combobox1.additem "C" userform1.combobox1.additem "D" Cheers JulieD "robroy" wrote in message ... I am totally stumped by this. I am trying to create a combo box that when I click on it, it will show me a lfrop down list of "A", "B", "c" AND "D" for me to pick one. I cannot even seem to get started the drop down list keeps coming up blank? Hope someone can help me. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
can use you Data / Validation - Debra Dalgleish has some great notes & examples at her web site www.contextures.com/tiptech.html Cheers JulieD "robroy" wrote in message ... I am totally stumped by this. I am trying to create a combo box that when I click on it, it will show me a lfrop down list of "A", "B", "c" AND "D" for me to pick one. I cannot even seem to get started the drop down list keeps coming up blank? Hope someone can help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
Combo Boxes and Tick Boxes | Excel Programming | |||
Combo Boxes and Tick Boxes | Excel Programming |