Add item to comboBox "form" from vba

  • Thread starter Thread starter 0000_AAAA_0000
  • Start date Start date
0

0000_AAAA_0000

Hi!

how can I add 2 items say "QAZ" and "WSX" to a ComboBox inserted in th
activesheet using the forms toollbar


from VBA


Sub help()
with activesheet.combobox1
.additem "QAZ"
.additem "WSX"
end with
'this work when the combobox comes from the activecontrols toolbars bu
when 'from the other toolbar?
ens sub


many thanks
 
Sub help()
with activesheet.DropDowns(1)
.additem "QAZ"
.additem "WSX"
end with
end sub

Replace the 1 with the name of the dropdown (found in the name box when the
control is selected) if you wish.
 
Back
Top