Help with userform code looping and bringing error

Hello,

I have the following code:

Please Login or Register  to view this content.

However, if there is only one entry that matches the search criteria put into the active cell, then it brings up an error saying "runtime error 91, object variable or with block variable not set". It errors on this piece of code:

Please Login or Register  to view this content.

However when there is more than 1 entry that matches the criteria, it works perfectly

Can anyone help?

PCI

Which code are you saying I should try replacing with your suggestion?

Thanks

That brings up the userform (when it shouldn't) with no entries, so doesn't sort it unfortunately.

See attached sample file

Sample 11-09-15.xlsm

Hi there,

The problem is being caused by the highlighted line:

Please Login or Register  to view this content.

The calling routine contains the line:

Please Login or Register  to view this content.

but before that command can be executed, the UserForm has already been unloaded.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg,

That does look like the problem, although I'm now confused as to how to solve it whilst still getting the userform to close if there is only 1 matching entry?

Taking out the unload me means that the userform just stays open with the one matching entry in the listbox.

Hi again,

Try using the following versions of your routines:

Please Login or Register  to view this content.

and:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Thank you! All sorted

Hi again,

Great! Glad to have been able to help.

Many thanks for your feedback and also for the Reputation increase - much appreciated.

Best regards,

Greg M