 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / May 2008Editing selected table cell in VBA
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 This should help http://www.pptfaq.com/FAQ00790.htm  Signature------------------------------------------- Amazing PPT Hints, Tips and Tutorials http://www.PPTAlchemy.co.uk http://www.technologytrish.co.uk email john AT technologytrish.co.uk > Hi All > [quoted text clipped - 5 lines] > > Thanks in advance 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! > This should help > http://www.pptfaq.com/FAQ00790.htm [quoted text clipped - 8 lines] > > > > Thanks in advance 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 > Hi All > [quoted text clipped - 6 lines] > > Thanks in advance 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 > There are some examples of working with tables here: > http://skp.mvps.org/ppttable.htm [quoted text clipped - 16 lines] > > > > Thanks in advance > 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 [quoted text clipped - 22 lines] > > > > > > Thanks in advance ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.