LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default How to work multiple ifs

Please ignore the previous most with the same name, something went goofy when
I tried to post. Is there any way to delete the first post?

What I am looking to do is call one of three macros depending on the
contents of a cell. If I have my code to look like below, the second macro
is run regardless if it is true or not.

Sub Special_Terms()
If AH13 = AH6 Then
Call Special_Terms_Frank
If AH13 = AH7 Then
Call Special_Terms_Jack
Else
Call Delete_Special_Terms
End If
End If
End Sub

If I change the code that is below, it returns the first macro regardless of
it being true.

Sub Special_Terms()
If AH13 = AH6 Then
Call Special_Terms_Frank
ElseIf AH13 = AH7 Then
Call Special_Terms_Jack
Else
Call Delete_Special_Terms
End If
End Sub


Can anyone explain what the difference in each of the two options above and
how do I make only the true macro run?




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to work multiple ifs Homer Excel Programming 1 August 27th 09 05:43 PM
need a function that will work using multiple work books and sheet capt c Excel Worksheet Functions 1 March 30th 09 10:20 PM
Getting multiple IF statements to work Psycho0426 Excel Discussion (Misc queries) 15 August 18th 06 04:31 PM
Counting dates in multiple work sheets and work books Savage Excel Discussion (Misc queries) 0 December 19th 05 11:41 PM
Multiple Work Sheets Daniell Excel Worksheet Functions 4 January 26th 05 02:08 AM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"