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.
0 · ·