How can I grey out specific dates in a Calendar Control within a VBA User Form?

I've got a user form with a calendar control that comes with Excel (as described in or

Is there someway I can grey out an arbitrary number of dates in the calendar so they are not selectable?
Who is Participating?
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
No, that control does not support disabling specific dates and I don't know one that does.

I believe your best course of action is to use the Click event handler for the control and check the selected date. If not valid then display a message or set the date to the nearest valid date.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.