Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
limiting rows of text in a textbox object?
Hello.
Is there a way to limit the rows of text in a textbox object (placed in a worksheet, not a form). The users want to be able to stop a user from entering more than a certain amount of text. They don't want any error message to appear (as the Data-Validation does). They just want it to stop accepting text when it reaches the visual limit of the space. With a cell, I didn't figure out a way to do this, because there is no 'keydown' event to check text as it is being entered.... only the worksheet change event after the ENTER key is pressed, or another cell selected. In the textbox control, there is a 'keydown' event... so live checking can happen. I see the character limit property.. but that doesn't do what is needed, well. For instance, characters are not all the same widty, so even if you typed across the whole row, the space would be filled with a different number of characters, depending upon specifically what characters were entered. What is needed is a count of the rows of text. Is that possible in either a textbox control, or in a cell itself with wrap text turned on? Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
limiting rows of text in a textbox object?
got it.
LineCount property. sorry. don't know why I didn't see it earlier. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limiting Characters In Rows | Excel Discussion (Misc queries) | |||
Can anyone tell me how to hide rows that have 0 values and text. | Charts and Charting in Excel | |||
Deleting Rows Automatically using a Text File List | Excel Discussion (Misc queries) | |||
How do I search and replace text in a textbox in Excel? | Excel Discussion (Misc queries) | |||
how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) |