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

RE: Editing selected table cell in VBA by john

john
Thu May 08 03:15:01 CDT 2008

This should help
http://www.pptfaq.com/FAQ00790.htm
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk


"Marky Mark" wrote:

> 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

Re: Editing selected table cell in VBA by Shyam

Shyam
Thu May 08 07:10:43 CDT 2008

There are some examples of working with tables here:
http://skp.mvps.org/ppttable.htm
http://skp.mvps.org/ppttable2.htm

Regards,
Shyam Pillai

Image Importer Wizard
http://skp.mvps.org/iiw.htm



"Marky Mark" <MarkyMark@discussions.microsoft.com> wrote in message
news:E9352134-9B8A-446E-9A9B-9B2FB09A3180@microsoft.com...
> 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


RE: Editing selected table cell in VBA by MarkyMark

MarkyMark
Thu May 08 18:25:00 CDT 2008

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!

"John Wilson" wrote:

> This should help
> http://www.pptfaq.com/FAQ00790.htm
> --
> -------------------------------------------
> Amazing PPT Hints, Tips and Tutorials
>
> http://www.PPTAlchemy.co.uk
> http://www.technologytrish.co.uk
> email john AT technologytrish.co.uk
>
>
> "Marky Mark" wrote:
>
> > 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

Re: Editing selected table cell in VBA by MarkyMark

MarkyMark
Thu May 08 18:28:01 CDT 2008

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


"Shyam Pillai" wrote:

> There are some examples of working with tables here:
> http://skp.mvps.org/ppttable.htm
> http://skp.mvps.org/ppttable2.htm
>
> Regards,
> Shyam Pillai
>
> Image Importer Wizard
> http://skp.mvps.org/iiw.htm
>
>
>
> "Marky Mark" <MarkyMark@discussions.microsoft.com> wrote in message
> news:E9352134-9B8A-446E-9A9B-9B2FB09A3180@microsoft.com...
> > 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
>
>

Re: Editing selected table cell in VBA by Steve

Steve
Fri May 09 10:44:41 CDT 2008

In article <AE5F6A70-9B57-4945-ABCA-59C5B638128C@microsoft.com>, Marky Mark
wrote:
> 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?

Yes. You'll find that most example code either does this or assumes that the
shape in question has been selected by the user.

It's left as an exercise for the user (that'd be your good self) to modify the
code to operate on whatever shape you need it to. Usually it's no big deal.



>
> 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
>
> "Shyam Pillai" wrote:
>
> > There are some examples of working with tables here:
> > http://skp.mvps.org/ppttable.htm
> > http://skp.mvps.org/ppttable2.htm
> >
> > Regards,
> > Shyam Pillai
> >
> > Image Importer Wizard
> > http://skp.mvps.org/iiw.htm
> >
> >
> >
> > "Marky Mark" <MarkyMark@discussions.microsoft.com> wrote in message
> > news:E9352134-9B8A-446E-9A9B-9B2FB09A3180@microsoft.com...
> > > 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
> >
> >
>

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================