Greetings all,
I am trying to set up a Datepicker to have a yellow background colour if the current date when a user opens the UserForm is today. I am using the following code for TextBoxes & ComboBoxes and it is working fine but I'm not sure how to do the same with the Datepicker:
Not sure if this can be done but would appreciate any assistance.
Thanks!
I am trying to set up a Datepicker to have a yellow background colour if the current date when a user opens the UserForm is today. I am using the following code for TextBoxes & ComboBoxes and it is working fine but I'm not sure how to do the same with the Datepicker:
VBA Code:
If TierTime.Value = "" Then TierTime.BackColor = vbYellow
Not sure if this can be done but would appreciate any assistance.
Thanks!