Re: Limiting Size of Text Fields

From: RagDyeR (ragdyer_at_cutoutmsn.com)
Date: 08/20/04


Date: Fri, 20 Aug 2004 08:15:55 -0700

You're right, but with 50 being the *maximum* allowed (not a required
amount), I'd assume that using less would always suffice.
And with the warning in mind while typing, it's probably sufficient
(although I can think of two of my users who wouldn't stop at a 100)<bg>

-- 
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------
"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:4125538E.1050204@contexturesXSPAM.com...
You can warn users that the cell is limited to 50 characters, but do you
expect them to count each letter as they type?
There's nothing built in that will alert them when they've reached the
limit.
RagDyer wrote:
> <<"However, users won't be notified of the problem until they press the
> Enter key to complete the entry.">>
>
> How about the "Input Message" Deb, which can be utilized to display a
> warning, as soon as the cell is selected, that the cell is limited to only
> 50 characters?
-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Relevant Pages

  • Re: Add text based on imput in another cell
    ... The problem as I saw it was, if the warning ... That means when the user leaves the cell, ... went to edit the text in C21 and restore it when they were finished. ... Private Sub Worksheet_SelectionChange ...
    (microsoft.public.excel.programming)
  • Re: Add text based on imput in another cell
    ... The problem as I saw it was, if the warning were allowed to remain during editing, there would be no practical way to protect if from being modified. ... Consider if the user accidentally deleted the closing parenthesis from the warning message... ... That means when the user leaves the cell, a new warning message would be added to the remaining text in the cell. ... To protect the warning message against this scenario, I decided to remove it when the user went to edit the text in C21 and restore it when they were finished. ...
    (microsoft.public.excel.programming)
  • Re: copying named cells into new workbook
    ... If you are using the GUI, the warning you refer to cannot be ... Sub testIt() ... > without having the origin file name pasting in as well? ... > cell named XYZfrom One.xls into Two.xls will Two.xls have a cell called ...
    (microsoft.public.excel.programming)
  • Re: Pop-Up Message
    ... You could use an event macro with a msgbox or maybe ... > (Change the A1 to whatever cell you're working with) ... > Now on the Error Alert tab in the "Style" area choose Warning ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Paying developers to get features faster
    ... Let's not go off on a tangent of specific syntactic changes. ... Suffice it ... a warning. ... these can be documented so that users and future developers ...
    (comp.os.linux.misc)