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
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.