Thread: Pop-up calendar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BSc Chem Eng Rick BSc Chem Eng Rick is offline
external usenet poster
 
Posts: 118
Default Pop-up calendar

Hi BBFan

I'm not sure which Pop up calender you are using but below is a procedure
which uses the Microsoft DateTime Picker. When the start date is changed,
then the end date value tracks it. Be careful with this because if you change
the start date after you pick your end date, your end date will change.

Note the below procedure is inserted into the code for the userform NOT a
separate module. DTPicker1 is the start date and DTPicker2 is the end date.

Private Sub DTPicker1_Change()
DTPicker2.Value = DTPicker1.Value
End Sub

If this helps please click "Yes"
<<<<<<<<<<

"BumblebeeFan" wrote:

We use a pop-up calendar in one of our forms for users to select a start and
end date (only one calendar for both selections). Once the user selects a
start date, is there a way to have the calendar "pop-up" in the same month as
the start date rather than the default current month?

I've learned a great deal from reading other posts! This is a great place
for new "bigger, better, faster" ideas!