View Single Post
 
Old 01-10-2016, 08:02 PM
sfvegas sfvegas is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Jan 2016
Posts: 2
sfvegas is on a distinguished road
Default Macro code that prompts user to enter text, then does find/replace.

Hello out there! My Vb skills are beyond rusty so thank you very much in advance for your any and all assistance. Can someone please share some code for a macro that will:

1) Prompt a user who opens an existing PPT to enter a value, let's name. E.g. - "Please enter a name". Then the user clicks ok or enter.

2) Searches through every slide in the deck and where ever (literally) <Insert Name here> is found, it replaces that with the name the user entered.

Hopefully that makes sense. If someone can that code with me, I would be extremely grateful! Many thanks again!


P.S. - in case it matters, I'm using MS office 2011 (version 14.1.3)
Reply With Quote