VBA Powerpoint Macros: Set String in one Macro, use it in another
I'm trying to create a Macro in Powerpoint so that when a list of certain items is presented, I can select a few of those and then use that information in a different macro to automatically place a picture in a Powerpoint for each item selected.
I already managed to get the second part done, so placing the pictures in the powerpoint is no problem.
My problem lays with the selecting part. The way I figured to do it is to create a macro for each item in the list so for example the list is:
- Bed
- Bug
- Bath
- Broom
In front of each item I want to place a square which when clicked upon would be ticked off and sets a string to a certain value so if you would click on the box of 'Bed' it would put a tick in that box and do:
strEquip1 = "Bed"
In the second Macro, which will only be used as soon as all items needed were selected, I want that string from the other Macro to be imported so it would only import the strings that were created by clicking those boxes in other macros.
I hope my explanation makes a bit of sense, I'm not a programmer at all and I'm doing this as a side project for myself and for fun.
Thanks in advance for the help!
|