Hi there, I'm relatively new to VBA in Excel and I stumbled across this forum in hopes that my problems can be solved.
It might be an easy task for VBA experts, so I just wanna ask as the thread title stated;
How do I automatically display text in a range of cells (multiple columns) when the cell(s) are empty, and even after I entered value inside and then deleted it, the cell will automatically display the same text that I set for the rest of the cells?
I tried the If Then function, but it only works on one cell and does not automatically display when I typed a value and deleted it.
I tried Googling but the codes that were given were something I don't understand, which I can't work it out in the end. I need help and I would also appreciate if someone explain to me on their solution in layman terms as I am trying to learn VBA along the way as well.
Thanks in advance
It might be an easy task for VBA experts, so I just wanna ask as the thread title stated;
How do I automatically display text in a range of cells (multiple columns) when the cell(s) are empty, and even after I entered value inside and then deleted it, the cell will automatically display the same text that I set for the rest of the cells?
I tried the If Then function, but it only works on one cell and does not automatically display when I typed a value and deleted it.
I tried Googling but the codes that were given were something I don't understand, which I can't work it out in the end. I need help and I would also appreciate if someone explain to me on their solution in layman terms as I am trying to learn VBA along the way as well.
Thanks in advance