ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Textbox restriction (https://www.excelbanter.com/excel-programming/304849-textbox-restriction.html)

newbie

Textbox restriction
 
Is there a method of restricting a textbox to accept only two digits?

TIA

Tom Ogilvy

Textbox restriction
 
No built in way. You would have to use the change event or other
appropriate event for a control toolbox toolbar textbox or for a textbox
from the drawing toolbar, use the OnAction macro. It wouldn't be a
restriction, but a notification and rejection if it didn't comply.

--
Regards,
Tom Ogilvy

"Newbie" wrote in message
...
Is there a method of restricting a textbox to accept only two digits?

TIA





All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com