#1
|
|||
|
|||
how to concatenate text box on new slide
Hi
My knowledge: powerpoint knowledge = 4 vba knowledge = 3 with that out of the way... have an issue i cannot seem to solve. Created a slide. In the slide there are 16 activex text boxes where the user will fill in the data. Now on the following slide i would like to combine all their answer into one text box. example: slide 1 the user enters the following Textbox 1 = "OVC150" textbox 2 = "12/10" Slide 2 would combine them as follows. "OVC150 12/10" is this possible? Currently on slide 2 i have 16 activex textbox that are linked with slide 1's textbox and it works but due to that some answers are longer or shorter than others, there are considerable spacing issues, so would like to resolve that with something like concatenate. any help would be appreciated. Thanks |
#2
|
|||
|
|||
Don't use ActivX on Slide 2 this will make the code much easier
See the sample for one way to do this. |
#3
|
|||
|
|||
Thanks john for the reply. I'll try it out and let you know how it works out.
|
#4
|
|||
|
|||
John
one other thing. I have the user entering the info on slide 7 but want to display it on slide 4. (The slide numbers are off because i preinstalled 4 slides in the beginning). What do i need to change on the code so slide 4 displays the users info on slide 7? |
#5
|
|||
|
|||
You just need to adapt
Set osld = ActivePresentation.Slides(1) Set osld2 = ActivePresentation.Slides(2) To point at slide 4 and 7 |
#6
|
|||
|
|||
I think i almost have it. But on your second slide what text box are you using, for the info to display on?
I've tried to locate the exact one, but having no luck. A blank text box just disappears. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Concatenate with @ symbol | anickles | Excel | 2 | 02-06-2015 09:39 AM |
Lyric slide show - using a variable to pull text from next slide | elfman12 | PowerPoint | 3 | 03-08-2013 12:27 AM |
Text typed on slide x ports to slide y automatically? | Thinker | PowerPoint | 5 | 07-26-2012 11:59 PM |
slide image wont copy with text to new slide | lewis.mulhollen | PowerPoint | 1 | 12-17-2011 03:17 AM |
If, move and concatenate in VBA | devcon | Excel Programming | 0 | 07-04-2011 12:44 AM |