Record of Excel commands

This code reflects the the changes made to the worksheet and displays a message box of what was done.
Apparently the information is stored in Application.CommandBars("Standard").Controls("&Undo").List(1).
I have used it elsewhere and it has caused me issues, since at the start there seems to be "nothing" or "no information" in this variable.
So, if I do something in the worksheet and then press the UNDO button, I get an error message.
I've tried to test for vbNullString and "" but nothing works. If there is nothing, it should Exit so there is no error message.

THIS WORKBOOK

Please Login or Register  to view this content.

CLASS MODULE

Please Login or Register  to view this content.

Hi there,

Will a simple "ignore error" approach help?

Please Login or Register  to view this content.

Regards,

Greg M

Greg, thanks for assisting, this will work.

.
Where is Excel getting the statement for the MsgBox ?

WhatExcelDid is not dimmed nor is it included in a "Set WhatExcelDid = blah blah blah" statement.

????

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M