Unfortunately, I don’t think this exact feature is possible in Excel, even through VBA. You could instead use the Workbook_SheetSelectionChange event to have placeholder text appear when a cell is not selected and disappear when the cell is selected or not blank.
https://www.reddit.com/r/vba/comments/1cnftup/excel_placeholder_text_code/



