ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   copy value calendar control (https://www.excelbanter.com/excel-worksheet-functions/251437-copy-value-calendar-control.html)

Rhino V

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.


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com