How to read pixel color

Hi,
How can I in Excels WorkSheet objects such as PlotArea or Shape using VBA and API determine pixel color at given coordinates. API function GetPixel requires handler - hdc so do Excels objects possess hdc and how can I get it? Or maybe there is another way to read pixel color ?

Hello Keram,

You would need the window handle (hWnd) of the chart to get the Device Context Handle (hDC) using the API. However, I believe the Chart is Owner Drawn which means there is no exposed handle to retrieve directly through Excel's objects or using the API calls. Sorry.

Sincerely,
Leith Ross

Hello

It's not exactly what you need but in the link below you will find a zipped workbook named "Palette_Couleurs_V01.zip " ( sorry... in french )

in the UserForm there is a Checkbox to have the pixel color at the coordonates of the mouse cursor (converts RGB , Long & Hex ) .informations are refreshed every second during Checkbox=true


http://www.excel-downloads.com/html/...009_132009.htm


regards
michel