Link to home
Start Free TrialLog in
Avatar of glenn_grubb
glenn_grubbFlag for United States of America

asked on

Update bulleted text with a variable

Let's say that I have 3 intended audiences: Water drinkers, Beer drinkers and Milk drinkers. I would like to have a text box control where I can enter in the work Milk and then have that word updated in the bulleted items of the show such as this

Milk drinkers are the smartest people
Other drinkers are envious of Milk drinkers
All the cool people drink Milk

You get the idea. I want the bulleted items to act as if the word Milk (or whatever word or phrase I supply) were always typed in as one would regularly do with a presentation.

Is such a thing possible
Avatar of John Wilson
John Wilson
Flag of United Kingdom of Great Britain and Northern Ireland image

How would you know where to insert the word?

Fairly easy to code but there would have to be some way of finding the insertion points or word to replace.

One way would be to store the last replace word in a tag. How good is your coding?
Avatar of glenn_grubb

ASKER

Figured it out myself! I can now use VBA to go to a specific line in a specific textbox on a specific slide and change that text to what I want. Will post the code when I clean it up.
Surely that would mean writing different code for each textbox though plus you will never be able to alter the presentation? Lets's hope there aren't too many things to change!

Maybe the code in this will help too.
ASKER CERTIFIED SOLUTION
Avatar of glenn_grubb
glenn_grubb
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I asked for an answer first hoping it would come quickly, when it didn't, I continued to research until I found the answer suitable to the task. I took a little code from here and some from there until I could work out my own solution... sort of a teach a man to fish  kind of scenario