TTom
Well-known Member
- Joined
- Jan 19, 2005
- Messages
- 518
I have a textbox in a userform and have an entry format issue.
I am requesting the user enter a payment amount and need to be certain it is digits only containing zero, one, or two decimal places.
It can not contain characters other than digits or period for decimal place.
Examples of acceptable entries:
200
2100
150.26
150.2
Examples of unacceptable entries:
2,100
150.253
$50
How to I write an error handler for this?
Thanks, TTom
I am requesting the user enter a payment amount and need to be certain it is digits only containing zero, one, or two decimal places.
It can not contain characters other than digits or period for decimal place.
Examples of acceptable entries:
200
2100
150.26
150.2
Examples of unacceptable entries:
2,100
150.253
$50
How to I write an error handler for this?
Thanks, TTom