Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

What's Wrong in my code

Posted on 2009-04-02
2
Medium Priority
?
242 Views
Last Modified: 2012-05-09
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
Comment
Question by:Whing Dela Cruz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Accepted Solution

by:
bmatumbura earned 2000 total points
ID: 24049593

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
 

Author Closing Comment

by:Whing Dela Cruz
ID: 31565773
Thanks to you,
the code is working
More power!
0

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question