Shape - Gradient Fill

[Tiger Chen]

In Excel, we can fill a shape with gradient colors. Two color's gradient filling including Forecolor and Backcolor. We can set either color into transparent manually.

However, with VBA, I can only set the forecolor into transparent. I cannot change the transparency of Backcolor - I even cannot record it when I do it manually.

When I look up transparency in Excel Help. It says transparency does not impact on gradient fill.

How can I set the backcolor into transparent by VBA code?

[johnske]

...When I look up transparency in Excel Help. It says transparency does not impact on gradient fill...That's correct, sorry, transparency just doesn't work on gradient fill, I can't set it manually either, let alone via VBA :)

[Andy Pope]

In xl2003 you can Manually set the From and To transparency for gradient fills.

In code you can set the From transparency BUT not the To.

[Tiger Chen]

This is really bad. Hopefully, Excel 2007 can fix the issue. Let me check it in 2007 tomorrow.