Runtime error '91' when trying to open userform in Excel

[GBrennan]

Hi,
I've created a bespoke userform in Excel 2016 for my sales manager and everything was going great until I started getting an error loading the form.
I have an active x command button that very simply opens the form with the code frmOrders.Show but I keep getting runtime error '91' every time I run it.
I can't understand it as it was working fine and then it just simply wasn't! It makes no sense as the code is right. I just don't get it... Has anyone else had the same problem? Can it be solved and how?
Thanks in advance,
G

[BanginMyHeadOnMyDesk]

The problem is more than likely with code in the userform initialize or activate event rather than anything to do with that command button.

Would it be possible for you to attach the file so we can investigate the issue?

Beth.

[Fluff13]

In the VB Editor, select Tools > Options > General > check Break in Class Module > Ok.
Then click your activeX button to open the form. You should then be able to find where the code is failing.

[GBrennan]

Thanks Fluff13 - that showed where the code was not working so now to solve where that line of code is going wrong!

[Fluff13]

If you care to post your code & explain what line is failing & what the error number & message are, I'm sure we could help.
A copy of the workbook would also help