View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Beginner via OfficeKB.com Beginner via OfficeKB.com is offline
external usenet poster
 
Posts: 1
Default ComboBox WorkSheet Trouble

Hello

Im trying to add the name of each worksheet to a combobox but so far I'm
having little luck, I want it to be done in this style:

sub userform_initialize()

For x = 1 to 30

combobox1.additem sheet & x.name

next x

end sub

This can't be far out but it doesn't work, does anyone know how to do this

--
Message posted via http://www.officekb.com