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
|