Thread: How do you write a macro with an IF Function
View Single Post
 
Old 06-04-2013, 10:03 AM
CGM3 CGM3 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default
Actually, if Balance is the available amount, and XctAmt is the (positive) "cost" that will be deducted, methinks the code should be:

Code:
   If Balance < XctAmt Then
      ' error message, etc
   Else
      ' deduct amount from balance
   End If
Reply With Quote