user form, code placement

S

Steve

morning all.
I've made the initial aspects of a user form.
In it I've placed 10 combo boxes.
I've found samples to use so I could populate my boxes with my desired
contents.
When I click on run, in the VBE, for the user form, my combo-boxes are not
populated.

Now, my question is--

What do I need to initiate the population of them when the userform loads?

Thank you in advance.
Best.
 
J

JLGWhiz

You can load them with the RowSource/ListFillRange method or with the
AddItem method as part of the UserForm_Initialize event code.
 
J

JLGWhiz

You can access the UserForm code module by right clicking on the form in
design mode, then select View Code from the pop up menu. Click in the
declarations panel of the code window to select the Initialize event and it
will put the correct procedure name and end lines in the code window for
you.
 
S

Steve

Hi JLG,
Ok, I did as you said, and see nothing that shows an initialize event.
When you say declarations, you're referring to the right side drop down that
lists all of the procedures in a given "module," correct?

Then,
I always keep my properties pane open, and have been through that a few
times-- no initialize.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top