Compile Error: Invalid Use of Property on stupidly simple code

[QueeniePie]

Evening all,

I have a userform with a button on it. That button, when clicked, should call a separate macro. So far I haven't made the separate macro all that difficult as I am just testing things out. Also I'm pretty sure I've done this before and it worked just fine but at this point I'm getting compile error: invalid use of property.

The Userform code reads:

Please Login or Register  to view this content.

and in a separate module the temporary code reads:

Please Login or Register  to view this content.

Any idea what I can be missing? That really is the only code in my worksheet at the moment and running through the ClearVehicles Sub manually will pop up a happy little MsgBox as I told it to.

[Norie]

Can't replicate the error.

Is that definitely the only code in the workbook?

Do you get a debug option when you get the error message?

If you don't goto Tools>Options... and on the General tab select Break on all Errors or Break in Class Module, then try the code again.

[QueeniePie]

The only other code on the worksheet is an on open event which opens the userform. Everything else is blank. The Workbook_Open event is also simple and works just fine.

I restarted the laptop as occasionally Excel decides that perfectly good code won't run until you do but still no joy.

Breaking on class module etc doesn't seem to give any sensible debug options but will show the error here:

Please Login or Register  to view this content.

[tehneXus]

Hi,

change the name of the Sub with the MsgBox to something else.

Mark this thread SOLVED and click the star if this answer solves your problem.

Regards

[Norie]

Actually I misread the original post and thought it was a runtime error not a compile error.

Have a look under Tools>References... and see if anything listed is marked as MISSING.

If there is anything uncheck it, but note it's name first, then save, close and exit Excel.

Then re-open the workbook and give the code a try.

[QueeniePie]

Hi,

change the name of the Sub with the MsgBox to something else.

Mark this thread SOLVED and click the star if this answer solves your problem.

Regards

It appears that Excel gets confused if things are named the same. Didn't realise >_<

This has solved the issue, thanks