Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 08-29-2014, 07:49 PM
excelledsoftware excelledsoftware is offline Quickly select lines of certain colour Windows 7 64bit Quickly select lines of certain colour Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Ok RFoudy,

Now that I have an idea of your experience level I will be more than happy to get you started with VBA coding. Now the big thing to understand is that this will be a process a lot of it will not make sense at first but you are just getting your feet wet.

You mentioned that you have done some HTML editing. That's great it gives you the opportunity to see how changing code of any kind can produce a different result.

so let's start with your project here. It is important to understand the logic of what you want the computer to do. You want code to look at all all sildes for each slide you want the code to look at all shapes. Determine if they are gray and then color them blue. After that we want the code to continue to the next shape then the next slide and repeat.

Some keywords to think about here are: All, every, repeat etc. When these words are used in your plan you need what is called a loop. A loop will execute a block of code and then keep on going until you tell it when to stop.

The other words used are: if

If statements are used in nearly every programming language they tell the code to execute something IF it meets a condition.

With that we now know that the code for this will consist of a loop that looks at all slides, in that loop we have another loop that looks at every shape on the slide. Within that loop an If statement that checks if the line is gray.

OK sounds fun dosnt it? Lets start with setting up the code so Powerpoint knows what we want it to do.

We will not go over every detail here but rather an introduction to the objects we are about to use.

In the next post we will start with the code and I will explain it as I go.
Reply With Quote
 

Tags
lines, multiple, select



Similar Threads
Thread Thread Starter Forum Replies Last Post
Quickly select lines of certain colour Way to find comments quickly ep2002 Word 2 12-18-2013 02:03 AM
Quickly add file path name to footer nimblewit Word 2 05-03-2013 05:17 AM
Quickly select lines of certain colour Is there a function to easily and quickly highlight? Verbum Word 3 02-05-2013 10:09 AM
Quickly select lines of certain colour How do I Insert Acrobat PDF pages into Word Canvases quickly? hemi_fan Word 1 04-12-2012 08:07 PM
finding contacts quickly Jackdeanperry Outlook 0 12-21-2009 11:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 PM.


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