Colour Option on Userform

[Molden]

Hi All,

This is more than likely not possible but thought I'd ask.

Is there any way of putting a fill colour box on a userform as in the one that you would use to change a colour of a cell manually (or any alternative).

I have done a userform that lets users to add options to a sheet with a userform but as a nice to have wanted them to specify a colour which I was going to pass to a listview box I am using.

Hope this makes sense.

Thanks in advance
Molden

 

[Jaafar Tribak]

You could mimic the color palette by adding colored labels to your userform then use the click event to retrieve the user's chosen color .

 

[Molden]

You could mimic the color palette by adding colored labels to your userform then use the click event to retrieve the user's chosen color .

Not a bad work around. I'll give it a go.

Thanks for your help