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

Don't use ActivX on Slide 2 this will make the code much easier

See the sample for one way to do this.

Attached Files

activx.pptm (66.6 KB, 13 views)

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

Thanks john for the reply. I'll try it out and let you know how it works out.

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?

You just need to adapt
Set osld = ActivePresentation.Slides(1)
Set osld2 = ActivePresentation.Slides(2)

To point at slide 4 and 7

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

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.