Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
martb
 
Posts: n/a
Default How do I prompt a user to update a cell value (ie the date)?


  #2   Report Post  
Richard Buttrey
 
Posts: n/a
Default

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
__________________________
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In excel how do I protect the format of a cell but let the user c. John Louis Excel Discussion (Misc queries) 11 October 1st 07 12:03 AM
Change color of cell after user has input a number F7772 Excel Discussion (Misc queries) 3 August 29th 05 09:20 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Update Cell Value Based on different Cell gonowhere Excel Discussion (Misc queries) 8 May 30th 05 05:13 PM
Help with user prompt Rob Gould Excel Discussion (Misc queries) 5 March 14th 05 12:38 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"