Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

What's Wrong in my code

What's wrong in my code?
The code would not identify the exact figure of the txtbox.
example if my Amntdue is 105 then AmntPaid is 104 it will not exit sub which supposed to exit sub

Private Sub cmdNext_Click()
    If AmntDue.text > Trim(AmntPaid) Then
        MsgBox "Hello"
            Exit Sub
                End If
End Sub

Open in new window

0
Whing Dela Cruz
Asked:
Whing Dela Cruz
1 Solution
 
bmatumburaCommented:

Private Sub cmdNext_Click()
    If CDBl(AmntDue.text) > CDBl(Trim(AmntPaid)) Then
        MsgBox "Hello"
            Exit Sub
                End If
End Sub

Open in new window

0
 
Whing Dela CruzAuthor Commented:
Thanks to you,
the code is working
More power!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now