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...
If (Me.txt_Fractional Like "00/00") Then
    fr = Me.txt_Fractional.value
Else
    Me.txt_Fractional = ""
    End If
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!