Bascially I have a routine that allows a user to select certain days of the
week using a MultiSelect listbox and a range of time in two inputboxes
(BeginDate and EndDate). Based on that criteria, the macro selects random
dates from the date range. I need to do two things:

1. Ensure that the random day selected is a day selected by the user in the
listbox
2. If the day is valid, I need to ensure that the date has not already been
selected

If either 1 or 2 are not valid, another random date must be chosen and then
tested against 1 and 2 again.

I have another project in which random numbers are selected and I call a
separate function to check for duplicate values. I tried using that and
another function to test for the valid day, but I'm getting lost when a new
date is selected and having to test for both criteria again.

Any help is appreciated.

TIA
Mike

--
Michael J. Malinsky