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