![]() |
#4
|
|||
|
|||
![]()
Hi
In the Validate_Fields() Function change: If Not Weekday(Range("B7").Value) = vbMonday Then MsgBox "Start Date must be a Monday (week beginning)", vbInformation to If Not Weekday(Range("B7").Value) = vbMonday Or vbTuesday Or vbWednesday Or vbThursday Or vbFriday Then MsgBox "Start Date must be a Weekday", vbInformation I think this will give you what you want. I am unable to step through the code because there are missing sheets. Hope this helps. Good luck. Tony(OTPM) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
parnol01 | Project | 1 | 12-16-2015 09:30 AM |
![]() |
Daria11 | Word VBA | 1 | 06-08-2011 06:54 PM |
![]() |
Ultrap3 | Word | 2 | 02-04-2011 02:53 PM |
![]() |
Ziggy-R | Word | 10 | 09-28-2010 01:42 AM |
Adding dates | mkkram | Word | 0 | 11-27-2006 09:18 AM |