Oct 29 2021 11:48 AM - edited Oct 29 2021 11:55 AM
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 words, when I click on a cell, move my shape to that cell, then it disappears after a few seconds. If another cell selection is made, show the shape again at the selected cell and then disappear again.
Oct 29 2021 12:22 PM
Solution
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.
Oct 29 2021 12:44 PM
Oct 29 2021 12:52 PM
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.
Oct 29 2021 12:22 PM
Solution
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.