Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit character length when copying or typing
I am creating a template with multiple columns that will be populated by
others. Some of these columns have specific character limitations--in these cases I'd like to prevent them from going over the character limit. I've considered using validation, but there is an excellent chance that some of the columns will be populated by copying/pasting, in which case validation doesn't help. I thought vba might be the best bet. What I'd love to have is this: If the person types or copies a value that exceeds the character limit, I would like a general message to display saying something like, "You have exceeded the character limit. Entries that exceed the limit will be highlighted and truncated." Then I would like that to happen--that is, to have their entry truncated to the max character limit, and that cell highlighted. I would like to have this work whether they pasted in one cell or multiple cells at a time. Does anyone have any ideas how I could accomplish this? Any guidance would be appreciated. Thanks, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SELECTING FROM A DROP DOWN LIST BY TYPING FIRST CHARACTER | New Users to Excel | |||
typing a complement (i.e. notA) character in Excel | Excel Discussion (Misc queries) | |||
How do I limit the character length of a cell when typing | Excel Programming | |||
Typing a quote character Vs pasting a quote character= what happens to the resulting CSV? Interesting!! | Excel Programming | |||
Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! | Excel Programming |