Cell color in native powerpoint table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I was wondering if there is a way that I can change the color of a (native
powerpoint table) cell programatically based on a user input. We develop a
slide show for customers and on each slide (amongs other information) is a
table with the results of five tests. Rather than changing each slide (up to
100) manually I was hoping to do it automatically.

I had thought about doing it two ways
1. A user form with the test results available as drop down box (the results
are simple numbers). I expect that this would be the easiest way as I can
create the table based on info in the form, or
2. Respond to change of data in the cell. This would be my preferred way as
it is more intuitive for my users. I do not think, however that it will be
that easy to implement.

Any help, advice or guidance appreciated,
Cheers
Rob
 
Hi all,

I was wondering if there is a way that I can change the color of a (native
powerpoint table) cell programatically based on a user input. We develop a
slide show for customers and on each slide (amongs other information) is a
table with the results of five tests. Rather than changing each slide (up to
100) manually I was hoping to do it automatically.

I had thought about doing it two ways
1. A user form with the test results available as drop down box (the results
are simple numbers). I expect that this would be the easiest way as I can
create the table based on info in the form, or
2. Respond to change of data in the cell. This would be my preferred way as
it is more intuitive for my users. I do not think, however that it will be
that easy to implement.
Click to expand...

Perhaps something in between? What about giving the user an "Update table"
button to click after they've made any changes to the table?

To make it automatic, I think you'd have to build an event handler (search on
"events" at http://www.pptfaq.com for an example).

You'd need to trap the selection change event and from there it gets a mite
tricky; you're not so much interested in the current selection as you are in
"Was the PREVIOUS selection a text range and if so, was the text range part of
a table?"
 
Back
Top