UserForms not running

[Jietoh]

Hello Everyone,

I think I'm running in circles. I'm working on a code that needs to open a Userform. On opening the UserForm needs to (1) open correctly and (2) pull information from the active row into various text and List boxes. The following is a simplified version of my codes:

Please Login or Register  to view this content.

However, every time I run this I get the following Error: run-time error '424' object required. I really don't know what I'm doing wrong.

To satisfy the second criteria I wrote the following code into my Userform:

Please Login or Register  to view this content.

There was a brief period where I was able to test the UserForm and this code only pulled information into the TextBoxes but not the ListBoxes. any help on this part would be great too.

Thanks in advance.

[Norie]

There's nothing obvious in that code that could be causing that error, perhaps a typo in a name.

Anyway. to try and find out what's wrong you could give this a shot.

Goto the userform module, put the cursor in the Initialize event and then use F8 to step through the code.

That should help you identify where the problem is.

[Jietoh]

Well that helped! Apparently the problem was here...

Please Login or Register  to view this content.

All of these lines referencing the listboxes was tripping the error. I removed those and the code works fine. So I guess my next question is how can I have that userform open up and (if there is an exact match) have the listbox selection equal the cell contents of a specific cell of my active row. For instance listbox1 = the 6th cell of the active row, if not an exact match then listindex = 0?

[Norie]

What are the names of the listboxes on the form?

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[Jietoh]

Thanks, but I figured it out. It cam down to order. I had my code to populate the cells first with the codes to fill the list boxes second. So when the UserForm opened it couldn't select anything in the listboxes because nothing had been loaded for it yet. I moved

Please Login or Register  to view this content.

to the end of my Private Sub UserForm_Initialize () section and everything worked. Thanks a ton for your help.