Where to populate Combo Boxes

**andrew c.** · 06-13-2011, 07:40 PM

I understand that in order to populate a combo box, you must do like so:

comboBox1.AddItem"1"

etc

However i am not sure where to put this code. I have a combo box on a form. This form is pulled up by a button I have on my worksheet where the macro is assigned to it. Is there a way to set it upon the creation of the form that is being brought up (upon click of the button)?

Thanks!

**jeffreybrown** · 06-13-2011, 07:45 PM

As an example which you would put in the code for the form.

Please Login or Register  to view this content.

**andrew c.** · 06-14-2011, 11:06 AM

Thanks!

So the form I am using is called Activities. Would I put this code where all the subs go for activities or would I put this in a module? I tried it in the activities and in my main module and it still isn't populating the combo box? Any suggestions?

**Mordred** · 06-14-2011, 11:15 AM

Right click the form Activities, select "View Code" and then insert it there.

Regards

**royUK** · 06-14-2011, 11:17 AM

In the VB Editor double click on the UserForm to open the code module for the form paste the code there

**andrew c.** · 06-14-2011, 01:08 PM

Guys this still doesn't work and I'm not sure why. I put this in the Activities worksheet code

Please Login or Register  to view this content.

My combo box is named ComboBox1, and the sheet is Activities. I'm just trying to get something to default populate it but I can't.

**jaslake** · 06-14-2011, 04:19 PM

Hi andrew c.

Attached is a working example for you to examine. It demonstrates both the ComboBox and the ListBox.

**andrew c.** · 06-14-2011, 05:57 PM

Thank You Very Much!

I had exactly what you put... still wasn't working. So I deleted the form and re-did it and it worked? Who knows why that works sometimes.

**jaslake** · 06-14-2011, 06:01 PM

Hi andrew c.

Glad to help...I'm a visual learner...examples ALWAYS help me.

You probably didn't have this code

Please Login or Register  to view this content.

So, your ComBox may well have been populated but you didn't see it.

**jolivanes** · 06-14-2011, 06:55 PM

or:
In post #6 you have

Please Login or Register  to view this content.

quote;
and the sheet is Activities
unquote

Might that be the problem? You referenced the sheet name instead of the userform name.

Where to populate Combo Boxes

LinkBack

Thread Tools

Rate This Thread

Display

Where to populate Combo Boxes

Re: Where to populate Combo Boxes

Re: Where to populate Combo Boxes

Re: Where to populate Combo Boxes

Re: Where to populate Combo Boxes

Re: Where to populate Combo Boxes

Re: Where to populate Combo Boxes

Re: Where to populate Combo Boxes

Re: Where to populate Combo Boxes

Re: Where to populate Combo Boxes

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions