PDA

View Full Version : Solved: VBA Combo Box Coding



JGobert
09-06-2007, 09:14 AM
This is the first time I have created user forms and I have a combo box. I want it to reference a list that already exists in the worksheet. For whatever reason I can't seem to figure out how to get that colomn to populate the dropdown box. PLEASE HELP!!!:mkay

rory
09-06-2007, 09:24 AM
In the properties window, set the Rowsource to your range - e.g. Sheet1!A1:A100

JGobert
09-06-2007, 09:31 AM
I had been doint that....I just needed someone to confirm that I wasn't missing half my brain........what I was missing was the apostrophies......(ie 'Sheet'!1 as opposed to Sheet!1).
thanks!!!!:bug:

lucas
09-06-2007, 10:14 AM
Try recording a simple macro where you select the range you're looking for...it will show you in the code how to select that range..

Use the recorder for these simple tasks...you can learn a lot that way.