Need Help Setting a Condition for a VBA Macro to Run

[unit285]

Flash Test.xlsm

So I am very inexperienced with VBA and am having trouble with solving this problem, I need for the Text Flash Code to activate ONLY when Range ("Info!C4") has the exact text of "You Must Enter a Selection Above To Continue!" in it. As soon as a user changed the cell contents to something else then the macro should stop. Currently the cell flashes all the time regardless of what the cell contents are. Any help is greatly appreciated!



Located in ThisWorkbook Module

Please Login or Register  to view this content.

Located in Module 1

Please Login or Register  to view this content.

[mehmetcik]

In a Normal Module

Please Login or Register  to view this content.

In the module for sheet "Info"

Right click on info ant the bottom of excel and select view code.

Paste this code into the macro module and close it,

Please Login or Register  to view this content.

[unit285]

Thanks for the reply.. after further testing i have decided not add this feature after all.

Thanks!