PDA

View Full Version : Listbox Values to Select ppt Shape



pierced84
04-07-2007, 01:32 PM
I have a listbox that is populated from an add button after the user selects stuff from two filtered comboboxes. (UserForm, VBA)

How can I take each row in the listbox and format a shape in PowerPoint based on a search for keywords in the value of each row in the box?

geekgirlau
04-09-2007, 09:10 PM
Are you saying that you want to search for text in the PowerPoint shape?

pierced84
04-11-2007, 03:15 PM
OK, I found a solution to this one, but I need some more help. What I did to get the listbox to format the shape was to delimit the properties in the text to separate cells. across the row. Then I can reference each cell in the row to specify what properties the shapes will have.

My next problem is how to get the ok button on the form to go through each row in all the columns of the range and do if..then statements to specify the location of the shape and how large the shape will be.