RGB font color of a disable ActiveX control

[Skysurfer]

Hi,

Does anyone know the RGB font code of a disabled ActiveX control?

Lawrence

 

[Micron]

AFAIK, Text in a disabled control is greyed out/ghosted by default and there is nothing you can do to change that. However, you can change the font colour if the control is locked instead. Unless you want non-standard colours, using the vb colour constants (e.g. vbRed) is much simpler than using RGB.

 

[Skysurfer]

Hey, thanks for the response. I don't want to change the disabled control's color. I want to match it on surrounding text. Just need the RGB code to do that.

Lawrence

 

[Micron]

I have no clue what you're asking for. First it's the "font code of a disabled ActiveX control". Font code could mean anything having to do with a font.
Now it's "match it" (whatever "it" is) to surrounding text. Text in adjacent cells? In adjacent controls on a userform? In the same textbox? Something else?
Maybe if you search on how to code for RGB and apply the property to something you'll be able to fill in all of the blanks faster.

 

[Bosquedeguate]

Your colors are determined by the theme color you pick for your Workbook. See Page Layout->Colors and/or Themes
There are constants are set by the theme colors.
Color Indexes for VBA

just a guess - it could be the color defined by
vbGrayText

 

[Skysurfer]

Good Peoples,

I have been unable to find an exact RGB match, but the closest my eyeballs can come is 166, 166, 166.

@Micron ... The purpose is to grey out descriptive text surround the ActiveX option button. If that option button is deselected, the surrounding text--which is a list of chart names--is no longer available.

Lawrence

 

[Bosquedeguate]

Good Peoples,

I have been unable to find an exact RGB match, but the closest my eyeballs can come is 166, 166, 166.

@Micron ... The purpose is to grey out descriptive text surround the ActiveX option button. If that option button is deselected, the surrounding text--which is a list of chart names--is no longer available.

Lawrence

Using a color-picker App it shows the disabled option button text is RGB(160,160,160). So, you are pretty close with 166.

 

[Skysurfer]

Using a color-picker App it shows the disabled option button text is RGB(160,160,160). So, you are pretty close with 166.

That's ever better!!! You rock.

~L