Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Hopefully Simple runtime error 424 ...
Please can you help as I am completely lost.
I have a Excel file. in it I have a sheet with nothing on it but a rectangle that is a link to a Macro.
The macro is simple (or so I thought). Click the rectangle and it will open up a user form.
But guess what! ... yep runtime error 424; object required.
The form name is frmMatchInsert so I can't see a problem. ALSO to add insult to injury I have got code for another file that is almost exactly the same (form name is the only change) and that runs ok.
Where have I gone wrong ?
Thanks for helping.