Getting RGB color from buttons on form

[Hasson]

Hi,
I would extract colors from RGB type for buttons on form using cells inside sheet.
seem HEX type in properties window when select button , but I have no idea how change from HEX to RGB
thanks

 

[RoryA]

The hex values look like this:

&H0080FFFF&

the two blue digits are the B values, the green are the G and the red are the R. You can actually use those values in the RGB function by prefixing them with &H (and remembering the correct order):

rgb(&HFF, &HFF, &H80)

 

[Hasson]

how use that inside sheet?
I don't see any cells reference to show RGB !

 

[RoryA]

How/where are you trying to use it?

 

[Hasson]

here is back color for commandbutton1 &H8000000F&
so I would change to RGB
not really sure if I need cells to populate RGB or I don't need cells.
the most important I would show RGB to use with drawing program.

 

[RoryA]

Ah, I'd forgotten that is actually a system constant, not a real colour value (or it would be black) - it was designed so that userforms would use the colour schemes set up in windows. You could simply screenshot the form into a graphics program with a colour picker (e.g. Paint) and get the RGB values from there. The default for a button is RGB(240,240,240) or 15790320

 

[Hasson]

You could simply screenshot the form into a graphics program with a colour picker (e.g. Paint) and get the RGB values from there

when open picture from PAINT program and edit color will select normal color is black . it doesn't show original RGB color !

The default for a button is RGB(240,240,240) or 15790320

thanks but I would how find out by paint program as you said.

 

[RoryA]

Paint has a colour picker which you can use to get the colour at a particular point in the picture (circle #1) and then the colours palette (circle #2) will show you the current RGB values for the selected colour:

 

[RoryA]

It may also be that your drawing program has a colour picker that you can use directly.

 

[Hasson]

Paint has a colour picker which you can use to get the colour at a particular point in the picture (circle #1) and then the colours palette (circle #2) will show you the current RGB values for the selected colour:

perfect !
thank you.

It may also be that your drawing program has a colour picker that you can use directly.

I suspect available with my version .