I would like to have a button when I click it, it opens up the color palette.
The one where you click on the paint can. And when I click on a color it
will Fill a static cell the color selected.

That's exactly what the paint can does to the selected cell.

pokdbz wrote:

I would like to have a button when I click it, it opens up the color palette.
The one where you click on the paint can. And when I click on a color it
will Fill a static cell the color selected.

What's wrong with using the paint can button?


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 10:22:02 -0700, pokdbz
wrote:

I would like to have a button when I click it, it opens up the color palette.
The one where you click on the paint can. And when I click on a color it
will Fill a static cell the color selected.

I want to have it so when they click on Text on the inside it brings up the
palette incase they want to change the color.

"Gord Dibben" wrote:

What's wrong with using the paint can button?


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 10:22:02 -0700, pokdbz
wrote:

I would like to have a button when I click it, it opens up the color palette.
The one where you click on the paint can. And when I click on a color it
will Fill a static cell the color selected.

That was not your original request which was to "fill" a cell with color.

You want to color just the selected text in a cell?

Select the text in the formula bar.

Click on the Font Color Icon and select the color you wish.

Just the selected text will be colored.


Gord

On Mon, 6 Aug 2007 13:22:03 -0700, pokdbz
wrote:

I want to have it so when they click on Text on the inside it brings up the
palette incase they want to change the color.

"Gord Dibben" wrote:

What's wrong with using the paint can button?


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 10:22:02 -0700, pokdbz
wrote:

I would like to have a button when I click it, it opens up the color palette.
The one where you click on the paint can. And when I click on a color it
will Fill a static cell the color selected.