Forum Discussion
Solved
How can I use VBA to move my shape and then after a few seconds make it disappear
So with help from a similar thread here, I can move the shape as desired, how would I make that shape disappear after a few seconds? And then reappear after another cell selection? So in other wo...
See the attached version. There is code in three modules:
ThisWorkbook - to stop scheduling the HideShape macro when the workbook is closed.
Sheet1 - the Worksheet_SelectionChange event procedure.
Module1 - to declare the dtmNext variable and the HideShape macro.
See the attached version. There is code in three modules:
ThisWorkbook - to stop scheduling the HideShape macro when the workbook is closed.
Sheet1 - the Worksheet_SelectionChange event procedure.
Module1 - to declare the dtmNext variable and the HideShape macro.
- what is the concern of stop scheduling when the file/workbook is closed?
If you don't do that, and if the shape were still visible when you close the workbook, the scheduled macro would reopen the workbook in order to run.
