populating list boxes and combo boxes in a user form.

First off, let me just say i'm at total n00b, but I got started down a rabbit hole, and am now fascinated with the possibilites of coding VBA for excel.

I'm basically trying to create a data entry user form which requires text inputs and I'd like to add in a list box and/or a combo box, but I can't seem to figure out how to populate the boxes. I've reworked a template I found online to suit my needs, and have googled (and tried) many different ways of populating the boxes from using the command .Additem to trying to get it to populate from a named range. I would appreciate any and all help!

I've attached my workbook to this post... If you could take a look and let me know what I can do to make it work, i'd really appreciate it!

thanks,
Jeanie

Welcome to the board!

For Fixed value list, such as the States, use Rowsource. Click on the combobox, then scroll down to Rowsource and enter Lists!A5:A55. Be sure that you don't try to modify the control in anyway, like using Clear. You'll get a strange error message that seemingly has nothing to do with the control.

For dynamic list, you can use a named range, or you can use a defined range.

Named Range Example

Please Login or Register  to view this content.

To use a defined range, use something like
Defined Range Example

Please Login or Register  to view this content.

Originally Posted by ahceinaej

..., you lost me with "then scroll down to Rowsource"
Where do I scroll?

Click on the combobox,

Make sure the properties window is visible. View -> Properties The items are in alphabetical order.

Make sure you comment out the code in the Initialize sub that refers to the States.

and neither of them worked.

Press F8 and step through the code, hovering over aCell and see what value debug shows you.

If it's empty, you may have to specify the sheet.

Please Login or Register  to view this content.

For the defined range, you'll have to set the LastRow property, too.

Please Login or Register  to view this content.