View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JASelep JASelep is offline
external usenet poster
 
Posts: 13
Default Data Validation - Calculated Error Title

using Excel 2003

I limit text input into a cell location to a certain length

I can only test for this length restriction after they press enter following
data input

if the length is exceeded, using data validation -
I have created an error message box to tell user of the length violation

I'd like to include (within the Error Title) what number of typed characters
was attempted to be entered, so the user knows how many characters they need
to reduce their response by

How do I include a calculated value into the error title

how do I reference the current cell for use in the calculation

I'm familiar with Access references but not how it is accomplished in Excel
--
Jim