Error opening userform (clicking button)

[adamstarr12]

Hello,

Thank you for your time and expertise!

The file: ExampleFile.xlsm - image of error segment below

The whole workbook is intended to be a vacation calendar for a company department, where employees can input their vacation requests. When using the macro, the error appears to occur at the "RetractRequestForm.show", but I think the actual error is located somewhere in the RetractRequestForm - Initialize section. Here is the section: RetractRequestForm.Initialize.JPG

This is intended to load the visible rows of a table (filtered) into a multicolumn listbox.

I appreciate your time and thoughts.

[Norie]

ActiveCell isn't a property of a worksheet, also using Rows.Count in this case will always return 1.

Try replacing this,

Please Login or Register  to view this content.

with this.

Please Login or Register  to view this content.

Actually try replacing the Initialize sub with this.

Please Login or Register  to view this content.

By the way, there seems to be quite a few errors throughout the code.

If you goto Debug>Compile then you should see what I mean.

[adamstarr12]

Hi Norie,

I appreciate the code you provided, it works very well.

One other question: I am wondering if there is a change to the code that will make it so there are only visible rows that show up in the multicolumn listbox? Here is what I have tried and it leads to error: RetractRequestForm.Initialize.JPG

Thank you,

Adam

[Trebor76]

Hi Adam,

Try this line of code...

Please Login or Register  to view this content.

...on the line that is erroring out and see how that goes.

Regards,

Robert

[adamstarr12]

Robert,

The code you provided works! Thanks for the help.


Adam

[adamstarr12]

Robert,

The code you provided works! Thanks for the help.


Adam

[Trebor76]

The code you provided works! Thanks for the help.

You're welcome and thanks for the rep

If you could mark the thread as solved it would be appreciated.

Regards,

Robert