Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Palette
I have a userform I want to be able to put several
identical controls on it that will allow me to access the colour palette in Excel. I want to be able to: 1) access the palette via dropdown button 2) choose a color 3) have the color show up on the dropdown button 4) and pass the color index number to a variable I know John Walkenbach had an example of this some time back. Does anyone know how to do this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Palette
Here is a link to J-walks tip:
http://j-walk.com/ss/excel/tips/tip49.htm -- Regards, Tom Ogilvy "ExcelMonkey" wrote in message ... I have a userform I want to be able to put several identical controls on it that will allow me to access the colour palette in Excel. I want to be able to: 1) access the palette via dropdown button 2) choose a color 3) have the color show up on the dropdown button 4) and pass the color index number to a variable I know John Walkenbach had an example of this some time back. Does anyone know how to do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color Palette | Excel Discussion (Misc queries) | |||
Color Palette | Excel Discussion (Misc queries) | |||
Bring up Color Palette to select color | Excel Discussion (Misc queries) | |||
Color Palette, color disappears | Excel Discussion (Misc queries) | |||
Changing color in color palette | Setting up and Configuration of Excel |