Color gradient
 

Hi,

I want to create with VBA some color gradients in my pallet. I know
that given a RGB color, a gradient is created changing the equivalent
HSL, changing L (say x RGB to white) . I don't know if this is the
best approach but I can't come with a formula to do that... any
ideas ?

thanks for your time
Mika