View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Populating Combo Boxes

right click on the combobox on the userform in the VBE and hit F4 to see the
properties box. Find the rowsource property and enter

Sheet1!A1:B3

find the columncount property and set it to 2.

--
Regards,
Tom Ogilvy


David wrote in message
...
Hey!
I have been looking for a while, and I can not find an
answer to my questions so I will post it. I would like to
know how you can take a range like A1:b3 on sheet1 and
have it populate a combobox1 on userform1.

TIA
David