ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Force use of a date picker control (https://www.excelbanter.com/excel-programming/376945-force-use-date-picker-control.html)

JT

Force use of a date picker control
 
On a worksheet, column A is the "Beginning Date", column B is a date picker
control for Column A, column C is the "Ending Date", column D is a date
picker control for Column C.

This worksheet will be used by many users and as a result, there will be
many different date formats. I would like to control this by forcing the
users to use the date picker controls to select the beginning and ending
dates.

Is there a way to display a pop up message if a user starts keying a date in
either Column A or C? If the user uses the date picker control, no message
would be displayed.

Thanks for the help.....
--
JT


All times are GMT +1. The time now is 05:57 PM.

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