UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> If Then Function, Office 2007    
 
   
d00d101
post Aug 3 2010, 03:22 PM
Post #1

UtterAccess Addict
Posts: 148
From: Texas



If I have...

If Create = vbYes Then

how do I tell it to skip or just continue instead of having to paste all of the code again under this If function?

This is my No... so if its Yes, I want it to skip over this and continue with the rest of the code.

ElseIf Create = vbNo Then
Sheets("Master Worksheet").Visible = False
Sheets("Data by Sold-to").Visible = False
Sheets("Next Steps").Visible = False
Exit Sub
End If

This post has been edited by d00d101: Aug 3 2010, 03:23 PM
Go to the top of the page
 
+
Jeff B.
post Aug 3 2010, 03:26 PM
Post #2

UtterAccess VIP
Posts: 8,170
From: Pacific NorthWet



If {this condition} Then
' do this (or do nothing!)
Else
' do that (or those things)
End If

Try checking Access HELP for detailed syntax...
Go to the top of the page
 
+
d00d101
post Aug 3 2010, 03:36 PM
Post #3

UtterAccess Addict
Posts: 148
From: Texas



Thank you, Sir.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 03:34 PM