Vba to open Fill colour palete and add the RBN number I choose to a cell

[tonywatsonhelp]

Hi Everyone,

So What I'm hoping can happen is when i click on celll D7 it opens the Fill colour picker, I can then choose any colour as normal and it put the colours RGB in cell D6

Is this even possible?
if so please help
Thanks
Tony

 

[Micron]

This might get you started

Calling and using the color picker with VBA - Excel Off The Grid

When building Excel-based tools and applications it is often useful for the user to select a color. Whilst it is possible to build a custom UserForm, Excel's

exceloffthegrid.com