Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 34
Default exit cell automatically after entering data

I want to require the user to enter his/her name in a specific cell (E59)
before the user can save the file.
I tried using Data Validation where I specified Text Length between 1 and
40, and left blank the check-box for "Ignore Blank". Nope. I never
programmed in VBA, so I hope there is a simple solution (I might be OK with
some simple VBA code).
---Pat
P.S. I posted this yesterday (Mar 19 2008) and someone was kind enough to
respond, but Microsoft's link (in the auto-generated e-mail to me) to the
response did not work. I thank that individual for responding, and ask that
you please re-send your answer.
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
Move to next unprotected cell automatically after entering data Patrick Riley Excel Discussion (Misc queries) 2 April 2nd 07 10:17 PM
Sorting dataset automatically after entering data in a row [or cel MatthewS Excel Discussion (Misc queries) 3 August 7th 06 09:47 PM
How does a cell automatically highlight itself after entering numb Janet Excel Discussion (Misc queries) 2 February 16th 06 04:02 AM
Can't move from one cell and/or enter any data, or exit wksht... Stuck in One cell Excel Discussion (Misc queries) 2 March 28th 05 06:19 AM
entering data in certain cell Craig Sayers Links and Linking in Excel 1 December 30th 04 04:17 PM


All times are GMT +1. The time now is 02:31 AM.

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

About Us

"It's about Microsoft Excel"