Excel Data Validation (Text Length)
<p>This will probably have to be something that is done in VBA, which is fine.</p>

<p>Some background information: I am wanting to use the text length option in Excel's Data validation. I am needing to limit to 60 characters or less. This is the easy part, however.</p>

<p>My question is, if a user has exceeded this 60-character threshold, I do not want my error alert to remain static and give a generic response saying "you must keep below 60 characters..." I want it to actually <em>count</em> the number of characters the user attempted to place in the cell, then on the Error Alert popup I would like it to be more specific, such as: <code>You have exceeded the 60-character limit by ## characters. Please shorten the input and try again.</code> Anyone know of a solution?</p>