Hello,

I know about min and max date, but need some additional functionality with an ActiveX Date Picker in my form.

I am building a user form (frmMilestones) that will allow a user to add events to a communications plan in Excel. The user will select a specific communication tactic or vehicle from a combobox (cboTactic) that is only available to publish on a certain frequency (let's say every 2 weeks on Fridays, using a predetermined date schedule). There is also a lead time in order to make the next available date (let's say 4 calendar days prior, so the prior Monday using the same example) that needs to be taken into account.

The business wants the user to be able to presented available start dates using an ActiveX Date Picker (dtpkrStart) that allows enough lead time as described above, using "today's" date as the reference date from which to calculate the first avaible start date. Moreover, then only show available dates on the frequency as described above such as every 2 weeks.

There will be other frequencies for other tactics too, such as the first Monday of each month.

Hope that all makes sense, but I can clarify as needed.

Any guidance on how to accomplish all of this would be hugely appreciated. Partial solutions are welcome too. I'm at a loss other than to manually create a range of dates to have the combobox reference as a source, but really don't want to do that.

Thanks in advance!
Chris