LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default auto shift down a cell


It can't be done if the user hasn't hit enter, however naturally when a
user hits enter the cursor usually moves down one row, if you only want
to allow a 4 digit number then use DATAVALIDATIONTEXT LENGTHEQUAL
TO4


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=37890

 
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
How can I shift curser within specific cell? amit Excel Discussion (Misc queries) 2 August 4th 08 10:55 AM
insert cell content and shift cells down Prohock Excel Worksheet Functions 1 May 8th 07 07:32 AM
Auto Shift Kelvin Lee Excel Discussion (Misc queries) 2 October 10th 05 06:39 PM
Shift cursor to the cell on the right Steved Excel Worksheet Functions 8 November 30th 04 01:42 PM
Cell Shift Sal Iaccarino Excel Worksheet Functions 1 October 29th 04 03:25 AM


All times are GMT +1. The time now is 01:02 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"