Hello Team,
Back here again for another question. That sounds like a vlog on YT. LOL
I have attached a sample workbook for this question.
On this workbook I have 4 dates, 1 on a label and was set during initialize.
The 3 other dates will be entered by the user on the textboxes.
What am I expecting to accomplish:
1. Each textboxes were assign to show "MM/DD/YYYY" during initialize. I set a MouseDown behavior on each textbox so when the user clicked on that textbox, the text "MM/DD/YYYY" disappears. The issue here is, when a user clicked outside textbox1 or clicked on textbox2 without putting any value on textbox1, it does not reset the textbox1 value to "MM/DD/YYYY". How would I go about setting that up?
2. I want to set all textboxes to only accept dates or numerical values instead of texts/letters., if possible.
3. I want to calculate the date difference of 2 dates but with different format outputs. First instance, I want to calculate the different of Date 1 and Date 2 but the output will be difference of Days. Second instance, I want to calculate the difference of Date 3 and 4 but the output will be difference of Years. Ideally, this will be calculated automatically once both dates are entered. Then, the output of the 1st instance will be displayed automatically on Textbox5. The output of the 2nd instance will be displayed automatically on Textbox6.