Bright01
asked on
Display and Disappear Text in Cell
EE Pros,
I am looking for some help in building a macro that does something very simple. It posts a text confirmation in a cell, to be displayed for 4 seconds, black text, yellow fill, then disappear. I plan to call the sub from other routines at the end as a confirmation of the sub being completed.
I have mocked up a sample for you.
Thank you in advance......
B.
Macro-for-Displaying-Text-in-a-Cell.xlsm
I am looking for some help in building a macro that does something very simple. It posts a text confirmation in a cell, to be displayed for 4 seconds, black text, yellow fill, then disappear. I plan to call the sub from other routines at the end as a confirmation of the sub being completed.
I have mocked up a sample for you.
Thank you in advance......
B.
Macro-for-Displaying-Text-in-a-Cell.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Occurs to me that I reset the cell to white. You may want to put it back as an zero-colour cell, in which case you'd need:
rshow.interior.colorIndex=0
Why not just use a message box at the end of the code? Much simpler in my opinion.
Maybe the formatting could be Conditional based on the text entry. The default formatting won't then need resetting.
ASKER
B.