Moutishake
New Member
- Joined
- Mar 5, 2018
- Messages
- 3
Hello everyone,
So I have been trying to do something in excel for some time without success.
I have found quite a few other posts online of people trying to do similar things, but didn't succeed.
I must say my VBA knowledge is non existent.
So what I would like to do:
I created a form in excel that will have to be filled on the job.
A previous form was used in the past, and one of the problem was the dates field. sometimes several dates format where used on the same form, which is uncomfortable.
So I would like the date cell to display, in light grey maybe in the background, the preferred format for the date, MM/YYYY, when the cell is empty.
But when data is entered, this instruction would disappear. And reappear again if the cell content is deleted
Thanks in advance to anyone who can help me with this
So I have been trying to do something in excel for some time without success.
I have found quite a few other posts online of people trying to do similar things, but didn't succeed.
I must say my VBA knowledge is non existent.
So what I would like to do:
I created a form in excel that will have to be filled on the job.
A previous form was used in the past, and one of the problem was the dates field. sometimes several dates format where used on the same form, which is uncomfortable.
So I would like the date cell to display, in light grey maybe in the background, the preferred format for the date, MM/YYYY, when the cell is empty.
But when data is entered, this instruction would disappear. And reappear again if the cell content is deleted
Thanks in advance to anyone who can help me with this