View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan Nordgreen Jan Nordgreen is offline
external usenet poster
 
Posts: 4
Default 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