Changing format in selected cells (VBA)

  • Thread starter Thread starter Roderick O'Regan
  • Start date Start date
R

Roderick O'Regan

I've seen many examples of code which insert a table and then change
nominated cells within it.

I've tried modifying these examples so that I can set foreground colours for
selected cells and get all sorts of errors depending on the mistake I made.

I suppose what I want to do say in VBA is: "With the selected cells in the
table turn the foreground colour into a specific RGB". I can manage the RGB
section OK. It's telling VBA how to recognise the selected cells that's the
problem!

Can anyone suggested a snippet of code, please?

Thanks

Roderick O'Regan
 
Thanks Shyam for the pointer. However, there seems to be an error in the
code but I havent the ability to spot what it is.

I create a table on a slide (Slide 1) using the Insert|Table command. I
select a couple of cells and then run your code. I get the following error:
<< Shape (unknown member). Invalid request. This shape does not have a tableproblem.

Also, if I have a table on slide 3 and I select cells there does it do that
table i.e. the active table shape in the active window?

I'm running this on PPoint 2002 and when fixed also in 2000.

Hope you can spot where the challenge exists.

Regards

Roderick O'Regan
 
Back
Top