| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access the 'color pick window'?
I am using Excel 97.
I would like to know how to use programmatically the window that opens when I click 'Fill Color' or 'Font Color' on the Format toolbar. I need to know how to open it, and how it returns the color the user chose. This gives a color window, but not the one I want: Dim x As CommonDialog Set x = New CommonDialog x.ShowColor Any ideas? Sincerely, Jan Nordgreen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to pick constant color to a value in a Pie Chart? | Charts and Charting in Excel | |||
| Shading cells - how to pick a slight/different shade of a color | New Users to Excel | |||
| How I auto fill a cell patern or color based on a pick list? | Excel Discussion (Misc queries) | |||
| I need to use a formula to pick up a value by the font color? | Excel Discussion (Misc queries) | |||
| Open Access Database under and Excel window using a Macro | Excel Worksheet Functions | |||
Threaded Mode
