View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
0000_AAAA_0000[_6_] 0000_AAAA_0000[_6_] is offline
external usenet poster
 
Posts: 1
Default Add item to comboBox "form" from vba


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

--
0000_AAAA_000
-----------------------------------------------------------------------
0000_AAAA_0000's Profile: http://www.excelforum.com/member.php...fo&userid=1248
View this thread: http://www.excelforum.com/showthread.php?threadid=27407