ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Textbox question (https://www.excelbanter.com/excel-discussion-misc-queries/30428-textbox-question.html)

browie

Textbox question
 
How do I get people only to put numbers into a textbox. If a letter is hit
by accident how do I get a message to say only number can be inputted.

Thanks




TC

Click on "Data" then "Validation" on the sub menu. Under "Vaidation criteria"
look for what you want then fill in the range. Then click on the "Input
message" tab to enter your "Enter only a whole number" message.

"browie" wrote:

How do I get people only to put numbers into a textbox. If a letter is hit
by accident how do I get a message to say only number can be inputted.

Thanks






All times are GMT +1. The time now is 01:10 AM.

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