How do you write a macro with an IF Function

		Microsoft Office Forums > Microsoft Excel > Excel
How do you write a macro with an IF Function

06-04-2013, 10:03 AM

CGM3

Windows XP How do you write a macro with an IF Function

Office 2007

Advanced Beginner

Join Date: Oct 2009

Posts: 38

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

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro or user function to Extract row height	Catalin.B	Excel	12	06-22-2011 09:21 AM
How to write a macro to find a specified name in a list of data?	Jaffa	Excel	1	10-23-2010 02:39 PM
automatic start of macro + help on writing helper function	vsempoux	Word	3	10-09-2009 03:01 AM
Macro or Function to know wether a string is included in a text	Eduardo	Word VBA	5	06-15-2009 01:55 AM
Help! for using an appropriate function/Macro in Excel	pawan2paw	Excel	1	06-04-2009 12:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:44 AM.