UserForm ComboBox problems

**RPhilbin83** · 07-22-2011, 01:23 PM

Hi all,

I don't know why my last post got deleted, so I'm sorry if I did something wrong...

I have done a bunch of research on this subject by reading through the posts here etc, but no matter what I try, it doesn't seem to work.

Basically, I am writing a macro in Excel where when you click a specific button, a UserForm appears asking for data from the user. One of the items is a ComboBox. In the ComboBox, all I want is one selection to be "Yes" and the other to be "No", but no matter what I do, I can't seem to populate these options in my ComboBox.

I have tried things like ComboBox1.AddItem "Yes" and putting that in the Form_Initialize() method, as well as several other things. Does anybody have any idea what I might be doing wrong?

Thanks for the help!!

**royUK** · 07-22-2011, 01:25 PM

Try

Private Sub UserForm_Initialize()
Me.ComboBox1.List = Array("Yes", "No")
End Sub

**RPhilbin83** · 07-22-2011, 01:27 PM

Hi Roy,

I saw that you did respond to my last post, so thanks for replying again. I have tried your suggestion, but my ComboBox still appears to be empty when I click the down arrow attached to its right...

**RPhilbin83** · 07-25-2011, 10:43 AM

Does anyone have any idea why I'm still having problems pre-populating my combo box with a "Yes" and "No" option? Is there a setting I need to select in Excel maybe?

Thanks for the help!

**romperstomper** · 07-25-2011, 10:45 AM

Roy's code will work assuming the combobox is called combobox1 and that you didn't alter anything else.

**snb** · 07-25-2011, 10:51 AM

Open the attachment.
Enable macros.

**RPhilbin83** · 07-25-2011, 11:09 AM

Thanks for your inputs guys... I have tried both of your suggestions, and still my combobox is blank when I open it...

My combobox is spelled correctly, I am calling it appropriately in the Initialize() method, and I even tried snb's code that you placed here. I am still at a loss for why it won't work...

**Colin Legg** · 07-25-2011, 11:16 AM

Hi,

It could be a number of things. So that we're not guessing, I think the best thing would be for you to attach your workbook to the thread so we can see it for ourselves.

**RPhilbin83** · 07-25-2011, 12:20 PM

Hi guys,

Attached is my spreadsheet. After enabling macros, to launch the form just push the button you see on the worksheet. The form will appear. The "Active?" label is next to the combobox in question.

Thanks very much!

**Colin Legg** · 07-25-2011, 12:29 PM

Change the name of this sub:

Private Sub EnterNewClientForm_Initialize()

To this:

Private Sub UserForm_Initialize()

**RPhilbin83** · 07-25-2011, 12:34 PM

Thanks so much Colin! That did the trick. I had no idea that I couldn't use the name that I specifically gave to the UserForm, and had to actually put "UserForm". This is definitely why I was getting confused. I saw all of these examples online, and took that as being a variable-like name.

Thanks again all!

**Colin Legg** · 07-25-2011, 12:38 PM

No problem. Above the code module you should see two dropdown boxes. When you want to create an event handler within a class module, you can pick the relevant class from the top left dropdown box (say, Userform, CommandButton1 etc....). You can then go to the right hand dropdown box and choose which event you want to handle (it will give you a list of available event handlers for that class). When you do this, the event handler procedure shell will be automatically placed in the code module for you.