Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LIMIT THE NUMBER OF CHARACTERS ENTERED IN A FIELD
I need to set fields to limit the number of characters entered, can it be
done in Excel 2007? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LIMIT THE NUMBER OF CHARACTERS ENTERED IN A FIELD
Describe what you mean when you say "fields"... Are they cells on the
worksheet? Or are they TextBox'es either on the worksheet or on a UserForm? If the latter, which is it, the worksheet or a UserForm. If the worksheet, where did you get the TextBox'es from? Or do you mean something else by "fields"? -- Rick (MVP - Excel) "RichN" wrote in message ... I need to set fields to limit the number of characters entered, can it be done in Excel 2007? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LIMIT THE NUMBER OF CHARACTERS ENTERED IN A FIELD
Go to Data section - Data Validation and use the Allow: text length.
"RichN" wrote: I need to set fields to limit the number of characters entered, can it be done in Excel 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent help needed? How do I limit the number of characters in a | Excel Discussion (Misc queries) | |||
Is there a limit number of characters for cells in pivot Tables? | Excel Discussion (Misc queries) | |||
Split field based on number of characters and space | Excel Worksheet Functions | |||
Limit the number of characters that a cell contains | Excel Worksheet Functions | |||
limit number of characters in a cell | Excel Discussion (Misc queries) |