-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
validation date
-
J
Date Picker - Validation to only allow workdays
Hello, I have a User Form with a DatePicker. I want to Add validation so that only future workdays can be selected (excluding both weekends and Holidays). Date Picker name = DTPickerLaunch Validation occurs on command: Private Sub CommandButtonContinue_Click() List of Holidays is located...- JustHooch
- Thread
- date picker msg validation date vblf workday function
- Replies: 0
- Forum: Excel Questions
-
O
Force cell entry strictly to mm/dd/yyyy
Using Excel 2007, and I want to force entry to calls in a date column to the format mm/dd/yyyy. Currently I have the cells formatted for mm/dd/yyyy and entered data validation date range between 12/31/1999 and 12/31/2060. However some users are too lazy to look up the day case start and just...- odonnell
- Thread
- date dd/mm/yyyy format cell validation date
- Replies: 7
- Forum: Excel Questions
-
F
data validation formula for 1st date of a month
I need the formula to put in validation, that user could only enter 1st date of any month. like 1/jan/12 or 1/dec/13- faizee
- Thread
- validation date
- Replies: 3
- Forum: Excel Questions
-
R
validation date n pop up msg
I want when excel file is opened. vba verify the date. if are on a certain date (eg June 30, 2012) will display a pop-up messages that have message: "The file needs to be updated. Click OK to renew or click Cancel to view the contents of the file" ... So in a pop-up messages have OK and Cancel...- ruro
- Thread
- validation date
- Replies: 3
- Forum: Excel Questions
