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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 07:34 AM.