Forum Discussion

Chris_Mugdan's avatar
Chris_Mugdan
Copper Contributor
Oct 05, 2023

Excel VBA ChooseColorAPI custom colors

I have searched for a document that describes the functionality of this API but I have not yet been able to find it. I am working on a product that makes use of this colour picker tool and I want to be able to keep the custom colours that I created when I first opened the tool and for them to appear when opening it subsequently. How can I do this?

Cheers,

Chris Mugdan

Macros and VBA

1 Reply

  • Chris_Mugdan's avatar
    Chris_Mugdan
    Copper Contributor
    Oct 05, 2023
    Hi,
    Don't worry about this one. I have solved it by making the variable that lpCustColors uses global.
    Cheers,
    Chris Mugdan

Resources