Combo Box in userform not loading

**sentinela** · 04-24-2009, 06:03 PM

Hello everyone.

Could someone help find out what I am doing wrong in this form?

The form is not uploading my dropdown box. I know I am missing something in the code, but I am not sure what.

Any help welcomed....

Thanks!

**Bjornar** · 04-24-2009, 08:32 PM

Try using the ComboBox1_Enter event instead of the Combobox1_Change event.

Private Sub ComboBox1_Enter()
    With Me.ComboBox1
           .AddItem "TEST1"
           .AddItem "TEST2"
    End With
End Sub

You should also rename your form to another name than APPLICATION , because application is already used as the basic namespace for the whole Excel application and this could lead to confusions

**royUK** · 04-25-2009, 03:13 AM

Controls are uually set up using the Initialize event of the UserForm


Private Sub UserForm_Initialize()
    With Me
        .ComboBox1.List = Array("Test1", "Test2", "Test3")
    End With
End Sub

You don't declar a variable to hold the userform, just use the keyword Me

**sentinela** · 04-27-2009, 11:37 AM

Thank you RoyUK and Bjornar.

Both of this works. After working on them today, I also realized if I set you the same coding as a Module, will also work just as well.

I appreciated all the work and the help

**royUK** · 04-27-2009, 11:40 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save