Checking for valid characters

[Brad]

Is there an easy way to take an input string and check for valid characters?
For instance, I am working on an expense report in where the cells have to
have numeric data only. So if the user accidentally inputs a space
somewhere in the data string, the program will error and alert the user to
this fact.

Thanks for the information.

Brad

 

[Larry Serflaten]

Is there an easy way to take an input string and check for valid characters?
For instance, I am working on an expense report in where the cells have to
have numeric data only. So if the user accidentally inputs a space
somewhere in the data string, the program will error and alert the user to
this fact.

Perhaps something like:

If strUserText Like "*[!0-9]*" Then
' Bad input
Else
' Good input
End If

LFS

 

[Brad]

Larry,

Thanks for the information. VB .Net has been a "learn as I go" process.

Brad

Is there an easy way to take an input string and check for valid characters?
For instance, I am working on an expense report in where the cells have to
have numeric data only. So if the user accidentally inputs a space
somewhere in the data string, the program will error and alert the user to
this fact.

Perhaps something like:

If strUserText Like "*[!0-9]*" Then
' Bad input
Else
' Good input
End If

LFS