No probs Cous'

Suggestion: To avoid errors when empty string ("") or an alpha character is entered
in either Text1 or Text2, validate them at the start of Command1_Click using:
VB Code:
  1. Option Explicit

  2.  
  3. Private Sub Command1_Click()

  4.  
  5.     If Not (IsNumeric(Text1.Text) And IsNumeric(Text2.Text)) Then

  6.         MsgBox "Numbers only please.", vbOKOnly + vbInformation, "Data Entry"

  7.         Exit Sub

  8.     End If

  9.  
  10.  
  11.     'Your Code Here........

  12.     '

  13.     '

  14.     '

  15.  
  16.  
  17. End Sub


Also, could you please edit your first post and select the green 'tick' to indicate that this tread is resolved.


Cheers,
Bruce.