View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rhino V Rhino V is offline
external usenet poster
 
Posts: 12
Default copy value calendar control

This is a 2 part question:
I have a calendar control attached to 3 cells (C6, E6, E7) designating
travel dates on the same sheet so users can pick the desired date they wish
to input.

Question 1: Once the date is chosen (which is always in the future from
today) why does it still show today's date when the cell is re-selected even
though another date has already been chosen? Can it be set to default to the
cell's already entered value?

Question 2: Once a date is selected for C6, how can E6 be defaulted to the
value of C6 so that date can be used as the starting point for the next
input? Do several Calendar Controls need to be set up for this to work?

Thank you in advance for any and all help on this.