VB Type Mismatch Error in Textbox

I have a TextBox that should only hold numeric values because there is a calculation eg(TextBox.Text = integer + integer) but if the user enters letters of course i get a type mismatch error because you cant add letters to numbers.

So i want some sort of error checking to check if letters have been enetered into the textbox?

cheers

Welburn1010
welburn1010Asked:
Who is Participating?
 
Mikal613Connect With a Mentor Commented:
if not isnumeric(trim(textbox.text)) then
 msgbox "Sorry!!"
End if
0
 
Mikal613Commented:
if not isnumeric(textbox.text) then
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
hongjunCommented:
one way is to restrict to only integers input

Private Sub Text1_KeyPress(KeyAscii As Integer)
    If KeyAscii < 48 Or KeyAscii > 57 Then
        KeyAscii = 0
    End If
End Sub



hongjun
0
 
Mike TomlinsonMiddle School Assistant TeacherCommented:
If you want only integers in your textbox you can also use the SetWindowLong API.  There is an example here:

http://www.galahtech.com/forums/index.php?showtopic=3080
0
 
Mike TomlinsonMiddle School Assistant TeacherCommented:
There is a more indepth article on how the API works here:

http://www.mvps.org/vbnet/index.html?http://www.mvps.org/vbnet/api/_consts/constse.htm
0
All Courses

From novice to tech pro — start learning today.