Editing selected table cell in VBA

M

Marky Mark

Hi All

I'm wanting to write a macro to modify the properties of some cells I have
selected in a table in ppt (but not every cell in the whole table). I can't
seem to work out how to let vba manipulate just the cells I have selected.

Is this possible? Can anyone help?

Thanks in advance
 
M

Marky Mark

Thanks John. Unfortunately this code only works if one cell is selected. I'm
looking to manipulate multiple cells at once. But Shyam's reply shows me how
to do this. Thanks all the same!
 
M

Marky Mark

Thanks Shyam. This is perfect.

Interestingly, the code on the 2nd page creates the array of the selected
cells, but then I think it relies on the cells being in table 1 on the first
slide (by virtue of the line "With ActivePresentation.Slides(1).Shapes(1)").
Is that right?

It doesn't matter for my purpose as I just edited the cells at the point in
the code where they were added to the array (probably a tad inefficient, but
works fine nonetheless).

Thanks for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top