ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Populating Combo Boxes (https://www.excelbanter.com/excel-programming/277935-re-populating-combo-boxes.html)

Tom Ogilvy

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





All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com