Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-05-2010, 09:46 PM
piper7971 piper7971 is offline if statement Windows Vista if statement Office 2007
Advanced Beginner
if statement
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default if statement


what am i doing wrong here:


Sub allbcgone()
If ActivePresentation.Slides(2).Shapes("bc1").Visible = False & _
ActivePresentation.Slides(2).Shapes("bc2").Visible = False & _
ActivePresentation.Slides(2).Shapes("bc3").Visible = False & _
ActivePresentation.Slides(2).Shapes("bc4").Visible = False & _
ActivePresentation.Slides(2).Shapes("bc5").Visible = False & _
ActivePresentation.Slides(2).Shapes("bc6").Visible = False & _
ActivePresentation.Slides(2).Shapes("bc7").Visible = False & _
ActivePresentation.Slides(2).Shapes("bc8").Visible = False & _
ActivePresentation.Slides(2).Shapes("bc9").Visible = False & _
ActivePresentation.Slides(2).Shapes("bc10").Visibl e = False & _
ActivePresentation.Slides(2).Shapes("bc11").Visibl e = False & _
ActivePresentation.Slides(2).Shapes("bc12").Visibl e = False & _
ActivePresentation.Slides(2).Shapes("bc13").Visibl e = False & _
ActivePresentation.Slides(2).Shapes("bc14").Visibl e = False & _
ActivePresentation.Slides(2).Shapes("bc15").Visibl e = False Then
ActivePresentation.SlideShowWindow.View.GotoSlide (38)
Else
ActivePresentation.SlideShowWindow.View.GotoSlide (2)
End If

End Sub


i am not sure if this is correct, but what i am trying to do is that when all the shapes are not visible the go to slide 38 . if not then go to slide 2 to continue until they are not visible. but is not wotking. can someone help?
Reply With Quote
  #2  
Old 08-19-2010, 07:10 AM
Jercook Jercook is offline if statement Windows XP if statement Office 2010 (Version 14.0)
Novice
 
Join Date: Aug 2010
Location: West Valley Utah
Posts: 13
Jercook is on a distinguished road
Cool Code has error in it

The first thing I would try is correct the spelling. Many of the last tests for visibility have 'Visible' spelled as 'Visibl e' which would cause the sub to be rejected.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
if statement Help with IF statement! CPelkey Word 1 04-12-2010 09:06 AM
Have you seen this error statement? nebb Word 4 12-01-2009 10:05 AM
if statement IF statement that adds text to a cell themangoagent Mail Merge 4 08-26-2009 08:07 AM
if statement Vlookup and If statement problem bunnygum Excel 1 03-24-2009 05:10 AM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft