How to validate Fractional number in userform textbox?

Hi!

I have a userform that should accept only fractional values, such as 7/21 , 1-7/8 and so on.
What is the best way to implement such validation and how?

For numerical values there's a method IsNumeric, however, is there anything I can use for Fractional numbers?

I tried LIKE method but it didn't work for me even if I know it wouldn't accept something similar to 1-7/8...

Please Login or Register  to view this content.

And I need to use it in Change event, so that user can input only allowed characters, such as "-" and "/" and digits.

Thank you in advance!

This should work using the Like operator repeatedly (note I assign the TextBox value to the String variable S because it makes the If..Then statement shorter)...

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

This method caused rejections as I typed "1-7/8" as in the OP. It rejected it as I typed each successive character,

Argh! I missed that the OP wanted to do this in the Change event character-by-character... my code was for approving the entry after all characters were typed in. I'm not exactly sure how you could validate this type of entry in a Change event. What if the user typed "1-" (without the quotes) and stopped? The entry is not valid as a final value but in a change event it would be allowed with the anticipation that a number would be typed next. Maybe the OP needs to tell us how his overall entry mechanism is supposed to work.