ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I prompt a user to update a cell value (ie the date)? (https://www.excelbanter.com/excel-worksheet-functions/44462-how-do-i-prompt-user-update-cell-value-ie-date.html)

martb

How do I prompt a user to update a cell value (ie the date)?
 


Richard Buttrey

On Thu, 8 Sep 2005 05:47:16 -0700, "martb"
wrote:

You'd need something like a Message box which would display when some
appropriate event happens.

You'd need to decide what the event should be. Look in VBA to see what
events are available for Workbooks, Worksheets etc.

Typically you might for instance want to prompt the user if they try
to Save the Workbook while the date cell is empty.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


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

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