View Single Post
 
Old 08-29-2014, 07:49 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit 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