View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default One letter per cell

Hi
I strongly suspect no. If you had such a facility then it would
automatically detect one character then stop you editing the cell
further. If you wanted to go back and edit the cell the same code
wouldn't let you....Cells can be contrived to have various activate
events (like click, double click etc) but typing a single character
isn't one of them. Possibly some clever way round this, but it may be
more bother than it is worth. Your users would expect to do something
after typing e.g. tab, return - and then you would get a double tab
(auto plus tab)!? Very annoying...
What you probably can do is force the cursor to go to the next cell in
the grid, without the user having to tab back to the start of the next
row. Would that do?
regards
Paul


On May 5, 2:31*pm, Bishop wrote:
I have a 5X5 grid which contains 25 cells. *I want to restrict each cell so
that only one letter can be entered into it. *And once that letter is entered
I want my cursor to tab to the next cell in the grid automatically. *So you
don't have to press enter or tab. *Is there a way to do this?