Issue opening (showing) a userform

Hello,
I'm trying to Show (open) a userform as per the macro below but it gives me an Run Time error: 1004 Application-defined or Object-defined Error.
Do you think there is a clash? this is supposed to be a straightforward macro.

Please Login or Register  to view this content.

Your help is much appreciated.

Hi davesexcel,
You are indeed right. it's that 'invrec_frm.Show' that is highlighted in yellow.
But I think the issue lies in the initialisation of the userform, that is, Userform.Initialize.
With this Sub, it will copy and paste data from a dynamic named range from a worksheet. However, that named range has yet no data in it, and as a result somehow when we open (show) the userform, it goes to that error.
I haven't figured yet how to resolve the issue but I reckon I should either use on error GoTo or if (named) range is empty Then ...

Hello,
This is the macro for the initialisation, which may be at the heart of the issue.
If the dynamic range is not empty then it will pull out the data as intended. However, as it is a new range with no data then it comes back as an error while trying to execute.

Please Login or Register  to view this content.

Can you please help?
Thank you

Hi rorya, (The Eton Rifles is definitely a song with a brilliant lyrics).

I think your rewrite suggestion works but when I now try to open the userform that will be initialised, nothing show up which should be the case. However, when the range is not empty - that is, has some data in it - it still doesn't show.

How should I address that please?

Thank you.

As requested,

I guess it won't make sense to open(show) the form when the database range is empty but it would be good to handle the error nonetheless.

If you populate the first row of the worksheet, the form will open when you click on the Update button.

Thank you.

Now, that doesn't make sense. I swear to God, I used your code in and it didn't open even with something.
Let me check something ....
Apologies.

Originally Posted by rorya

I'm not seeing what you're seeing. If I put that code in, the listbox is populated if I enter an invoice number onto the sheet.

Silly me rorya. I was on a debug setting and that's why it didn't show up. Once again, my apologies and thank you very much for your help.