Linking Combo Boxes with Data

[matthewmark]

I will be creating a powerpoint slide with unique shape names. I will also be
populating the text values from a sql server database. All that's good.

I want to be able to give the user the ability to select a value from a
combo box and then save it back to the database. I know of a way which would
be to loop through the shapes and based on the shape.name, put the text value
in the database. Is there a better, smarter way?

 

[matthewmark]

What I am referring to is, as you said loop through the shapes and get the
text with the shape.name. Having already saved the shape.name with other Keys
in the database, I simply update the table with the what I call text.value.
Whatever the property is called for when using a combo box.

thanks

 

[Brian Reilly, MVP]

Iterating through the shapes is the right way to do this. As Steve
hints at using tags on the shapes is more powerful than using the
actual shape.name since you can have lots of tags on a shape but only
one name. Check the tag property in the VBA help file.

Brian Reilly, MVP