Thread: COMBO BOXES
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default COMBO BOXES

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.