Run-time error '424' Object required

[china99boy]

Hello... can you can tell me what I am doing wrong here. I have a the code below in module and trying to have it populate my combobox. This works well when I run it under the UserForm_Initialize() event, but I sometimes need to run it independently.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[davesexcel]

Usually the msg will highlite the line that is in error.

You have mentioned you want to run the code independently, one would assume the code does not work independently because it is made for the userform.

[china99boy]

I am sorry I wasn't very clear. Currently I have this routine stored in the Private Sub UserForm_Initialize() along with some other items that I have running when the form is loaded. On another tab of the userform there is a delete function. When that runs, I need to update the combo box on the main tab. So I figured I can put the routine in its own module and call it when I need to.

The error occurs here "getCboListClasses cboClasses"
.

[Norie]

If the combobox cboClasses is on the userform and you are trying to run this code outside the userform module then you'll need a reference to the userform.

Please Login or Register  to view this content.

[china99boy]

I did try that, but I get Authentication failed, Run-time error '2147217843

[davesexcel]

In your original question, what line gets highlighted when the error happens.

[china99boy]

getCboListClasses cboClasses"

I think i need to pass parameters to the combobox and that i am not certain about.