GMaxey, I got the code you supplied to work. I understand some of your code. Very interesting, an Array. And two boxes appear. I have enough to go on now. The Select Case you used tests for weekdays.
Concerning this line:
fcnAdvancedDate(Optional StartDate As Variant, Optional DaysToCount As Long = 14) As Date
Where do I go to learn about the parts to the right and left of the comma ?
And the parentheses ?
Thanks,
|