Change Table Properties (PowerPoint)

[icu222much]

I am looking for a way to change the margin, font size, and the border width of the table once I have created the table.

At the moment, I have code tha goes through each cell and changes these properties. However, once I start having over 50+ cells per table, it starts to take PowerPoint a while to do this. There has to be a more efficient way to do this such as by changing the margin, font size, and border width once my table has been created and populated.

 

[SkipVought]

hi,

There has to be a more efficient way to do this ...

Yes. Use the best tool for the task.

The Graph object in PP is very elementary. If it were me, I'd do the chart in Excel, an application that is well suited for charting.

Then embed Excel the chart in PP.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[fumei]

icu222much, you are not being very good about polite responses. It is polite to respond to people. You have threads you have started and not replied to responses people have given.

Also, if a response is given and you do find it helpful there is a means to recognize the person who assisted you. Please use it.

Gerry

 

[SkipVought]

oops!

I just realzed, that I did not answer YOUR question regarding TABLES.

I have code tha goes through each cell and changes these properties.

Please post your code and lets see if we can refocus.

Sorry.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[fumei]

Yes Skip, I was wondering about that...

Gerry

 

[icu222much]

Fumei, I auctually try to be as nice as I can with my post. I only reply to posts when I have something to say. I don't want to bump a post just to say thank-you because I don't want to take up the top slots of the forum when someone else really needs help with their coding. If I happen to find a solution about my problem, I will post the solution so that it can help the next person who encounteres my post.
I never noticed the thank button - I will start using that.


Sorry about that. Here is my code:

With mySlide.Shapes(i).Table
.Cell(x, y).Shape.TextFrame.TextRange.Font.Size = 7
.Rows(x).Cells(m).Borders.item(ppBorderBottom).Weight = 1
.Cell(x, y).Shape.TextFrame.MarginBottom = 1
End With

I apply this code to all of the cells in a table and I find that it takes a long time for PowerPoint to do this. I am wondering if it is possible for me to create the table and populate the cells, then apply the properties to the entire table?

 

[SkipVought]

I am discovering the answer to your issue, using this technique...

faq707-4833

You might take a look while I am exploring.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[fumei]

I only reply to posts when I have something to say. "

Fair enough,

" I don't want to bump a post just to say thank-you because I don't want to take up the top slots of the forum when someone else really needs help with their coding.:

Huh?

1. Adding a post to thank someone is NEVER inappropriate.

2. How would that take up the tops slots of the forum? No, it would not.

3. Adding a post to thank someone is NEVER inappropriate.

Gerry

 

[icu222much]

SkipVought:
I took a look at the link you provided but I do not see how it relates to my problem.

Fumei:
I am sorry that I do not have the same forum philosophy as you do. If you would like to continue this conversation, please PM me instead of filling up this thread with your nagging

 

[SkipVought]

Sorry, I meant to post this link faq707-4594.

I have not yet had a good chance to look at your problem.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[icu222much]

I have tried using the Watch Window approach too see which properties I can use. I also tried to Google up examples to see if there are other solutions. I cannot find any.

 

[SkipVought]

So would it work to format an Excel table and embed the object?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[xlbo]

this would seem an appropriate reference:

http://skp.mvps.org/pptxp009.htm

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question