| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I shift curser within specific cell? | Excel Discussion (Misc queries) | |||
| insert cell content and shift cells down | Excel Worksheet Functions | |||
| Auto Shift | Excel Discussion (Misc queries) | |||
| Shift cursor to the cell on the right | Excel Worksheet Functions | |||
| Cell Shift | Excel Worksheet Functions | |||
![The Code Cage Team[_46_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
