Re: Can you limit the amount typed in a cell in Excel 2003?

I don't think that this will work when the user is typing in a cell.



Gary''s Student wrote:

Hi Dave:

I was thinking of using Steve Bullen's CheckKey technique to read keyboard
strokes as they were being entered:

http://www.oaltd.co.uk/Excel/Default.htm
--
Gary''s Student - gsnu200745

"Dave Peterson" wrote:

I don't think that this will work.

Your macro won't work while the user is typing in a cell.

Maybe creating a userform and counting the characters would work for the OP,
though.

Gary''s Student wrote:

It is difficult because of fonts and font sizes. It is much easier to count
the characters as they are being typed and shift down once a limit has been
reached.
--
Gary''s Student - gsnu200745

"Rezzolve" wrote:

I have a template I have used for years but the problem is everytime you fill
the cell up you have to stop, go down to the next cell and continue. Is there
a way to make it auto enter to the next cell when the range you are typing in
is full?

--

Dave Peterson


--

Dave Peterson
.

Relevant Pages

  • Re: Some of my SSNs are being treated as formulas
    ... apostrophe. ... Gary''s Student - gsnu200749 ... (When I look at the cell contents in the formula ... Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: Can you limit the amount typed in a cell in Excel 2003?
    ... have the status bar track the number of characters in the cell as they are ... Gary''s Student - gsnu200745 ... "Dave Peterson" wrote: ... Maybe creating a userform and counting the characters would work for the OP, ...
    (microsoft.public.excel.programming)
  • Continuation: Formula for Duplicating info from one cell to anothe
    ... I'd like information that I input into a cell to be automatically output into ... by excluding the HWC65917 P. ... Gary''s Student - gsnu200778 ... "Timbo" wrote: ...
    (microsoft.public.excel.misc)
  • RE: Help with VBA Code - once again
    ... Gary''s Student - gsnu200780 ... Private Sub Worksheet_Change(ByVal Target As Range) ... Is Nothing Then Exit Sub ... sheet1 and record what was entered, when and in what cell on sheet2. ...
    (microsoft.public.excel.programming)
  • RE: time auto entry
    ... Gary''s Student - gsnu200818 ... We can make a different macro. ... human data entry into one cell. ... Private Sub Worksheet_Change ...
    (microsoft.public.excel.misc)