Combo Box in userform not loading

[sentinela]

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]

Try using the ComboBox1_Enter event instead of the Combobox1_Change event.

Please Login or Register  to view this content.

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]

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

Please Login or Register  to view this content.

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

[sentinela]

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]

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