VBA - Empty Cells Show With Custom Text

[Stag Weekenders]

Hi all,

Im a total newbie at VBA And as a result, I’ve tried following various tutorials to achieve the below outcome, but no avail. Not sure of what to do beyond the point of pasting the VBA code into the workbook.

I need a VBA code that will work in such a way that whenever a cell is empty, the phrase “* Credit Available *” will appear. If a user then fills that same cell with a date, “* Credit Available *” will disappear. It‘s also important that the reverse will happen as well, ie. when a user deletes the date from said cell, “* Credit Available *” reappears.

Would greatly appreciate anyone who can advise on what code is needed and pointers on what to do after entering the VBA into the workbook (code).

Many thanks,
MJF.

 

[mumps]

In which cell relative to the empty cell do you want "*Credit Available*" to appear and disappear?

 

[Stag Weekenders]

Hi there,

the same cell if at possible

 

[mumps]

What cell or cells are we dealing with? I'm not sure what you want to use as a trigger to insert "*Credit Available*" into the empty cells. Do you want to do this when the workbook is opened? What is the name of the sheet with the cells in question?

 

[DataBlake]

that whenever a cell is empty,

surely you have a range you want this to apply to? all cells would be a little much