Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Limits & Moving to Next Cell
I'm looking to format some cells to only allow one character per cell. After
the character has been typed in the cell, I would like it to automaticallygo to the next blank cell without hitting enter or tab. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Limits & Moving to Next Cell
Do you want to go to the next blank cell to the right or downward?
-- Gary''s Student - gsnu200760 "SieversEQ" wrote: I'm looking to format some cells to only allow one character per cell. After the character has been typed in the cell, I would like it to automaticallygo to the next blank cell without hitting enter or tab. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Limits & Moving to Next Cell
You can't do this directly in XL - macros are disabled when in Edit
mode, so there's no way to intercept a single character without exiting that mode (via Enter, Tab, an arrow key, a mouse click, etc). In any case, formatting doesn't affect cell values or how input is handled (other than that setting format to Text bypasses XL's input parser). You might consider a Userform instead... In article , SieversEQ wrote: I'm looking to format some cells to only allow one character per cell. After the character has been typed in the cell, I would like it to automaticallygo to the next blank cell without hitting enter or tab. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value Limits in a Cell | Setting up and Configuration of Excel | |||
Microsoft Excel Cell text limits | Excel Discussion (Misc queries) | |||
PivotCharts (max cell/row limits)? | Charts and Charting in Excel | |||
cell format limits | Excel Worksheet Functions | |||
dealing with cell text limits | Excel Discussion (Misc queries) |