Hi

I posted this in the developers ng without response.

Anyone know what the centre or click areas of Option Buttons or CheckBoxes
are called and how they can be addressed?

This is in the context of changing the backcolors of other controls such as
textboxes. These click areas seem to remain the same color as the
application colors set for Excel in the Display Panel and sometimes stand out
like a sore thumb against the rest of a form.

T.I.A.

Geoff

If you use controls from the Control Toolbox you can set the backcolor
property

--
HTH

Bob Phillips

"Geoff" wrote in message
...
Hi

I posted this in the developers ng without response.

Anyone know what the centre or click areas of Option Buttons or CheckBoxes
are called and how they can be addressed?

This is in the context of changing the backcolors of other controls such
as
textboxes. These click areas seem to remain the same color as the
application colors set for Excel in the Display Panel and sometimes stand
out
like a sore thumb against the rest of a form.

T.I.A.

Geoff

Hi Bob and RB Smissaert
Backcolor only addresses the area surrounding the click area, in other words
where the text for the control is, as far as i can tell. Please tell me if i
am wrong. I am trying to address the area where the black point or tick
appears when clicked.

Geoff

"Bob Phillips" wrote:

If you use controls from the Control Toolbox you can set the backcolor
property

--
HTH

Bob Phillips

"Geoff" wrote in message
...
Hi

I posted this in the developers ng without response.

Anyone know what the centre or click areas of Option Buttons or CheckBoxes
are called and how they can be addressed?

This is in the context of changing the backcolors of other controls such
as
textboxes. These click areas seem to remain the same color as the
application colors set for Excel in the Display Panel and sometimes stand
out
like a sore thumb against the rest of a form.

T.I.A.

Geoff

No, you are not wrong, but I don't think that its exposed to VBA.

--
HTH

Bob Phillips

"Geoff" wrote in message
...
Hi Bob and RB Smissaert
Backcolor only addresses the area surrounding the click area, in other
words
where the text for the control is, as far as i can tell. Please tell me
if i
am wrong. I am trying to address the area where the black point or tick
appears when clicked.

Geoff

"Bob Phillips" wrote:

If you use controls from the Control Toolbox you can set the backcolor
property

--
HTH

Bob Phillips

"Geoff" wrote in message
...
Hi

I posted this in the developers ng without response.

Anyone know what the centre or click areas of Option Buttons or
CheckBoxes
are called and how they can be addressed?

This is in the context of changing the backcolors of other controls
such
as
textboxes. These click areas seem to remain the same color as the
application colors set for Excel in the Display Panel and sometimes
stand
out
like a sore thumb against the rest of a form.

T.I.A.

Geoff

Looks you are right there.
I thought there was a way to alter the color of the circle itself, but can't
see it now.
Maybe you could simulate option buttons with small text boxes.

RBS


"Geoff" wrote in message
...
Hi Bob and RB Smissaert
Backcolor only addresses the area surrounding the click area, in other
words
where the text for the control is, as far as i can tell. Please tell me
if i
am wrong. I am trying to address the area where the black point or tick
appears when clicked.

Geoff

"Bob Phillips" wrote:

If you use controls from the Control Toolbox you can set the backcolor
property

--
HTH

Bob Phillips

"Geoff" wrote in message
...
Hi

I posted this in the developers ng without response.

Anyone know what the centre or click areas of Option Buttons or
CheckBoxes
are called and how they can be addressed?

This is in the context of changing the backcolors of other controls
such
as
textboxes. These click areas seem to remain the same color as the
application colors set for Excel in the Display Panel and sometimes
stand
out
like a sore thumb against the rest of a form.

T.I.A.

Geoff

Hi RBS and Bob
Wayyyyyy back i thought i had seen a piece that did something like that but
with a command button overlay and used zorder but for the life of me i cannot
find it anymore. In the meantime i just hoped some smart person may well
have got a simpler workaround.

Thanks to you and Bob for the comments. To Bob a second no no from MS today
re palette colors as well :) :)

Geoff

"RB Smissaert" wrote:

Looks you are right there.
I thought there was a way to alter the color of the circle itself, but can't
see it now.
Maybe you could simulate option buttons with small text boxes.

RBS


"Geoff" wrote in message
...
Hi Bob and RB Smissaert
Backcolor only addresses the area surrounding the click area, in other
words
where the text for the control is, as far as i can tell. Please tell me
if i
am wrong. I am trying to address the area where the black point or tick
appears when clicked.

Geoff

"Bob Phillips" wrote:

If you use controls from the Control Toolbox you can set the backcolor
property

--
HTH

Bob Phillips

"Geoff" wrote in message
...
Hi

I posted this in the developers ng without response.

Anyone know what the centre or click areas of Option Buttons or
CheckBoxes
are called and how they can be addressed?

This is in the context of changing the backcolors of other controls
such
as
textboxes. These click areas seem to remain the same color as the
application colors set for Excel in the Display Panel and sometimes
stand
out
like a sore thumb against the rest of a form.

T.I.A.

Geoff

Sorry to be such a merchant of gloom :-(

Bob

"Geoff" wrote in message
...
Hi RBS and Bob
Wayyyyyy back i thought i had seen a piece that did something like that
but
with a command button overlay and used zorder but for the life of me i
cannot
find it anymore. In the meantime i just hoped some smart person may well
have got a simpler workaround.

Thanks to you and Bob for the comments. To Bob a second no no from MS
today
re palette colors as well :) :)

Geoff

"RB Smissaert" wrote:

Looks you are right there.
I thought there was a way to alter the color of the circle itself, but
can't
see it now.
Maybe you could simulate option buttons with small text boxes.

RBS


"Geoff" wrote in message
...
Hi Bob and RB Smissaert
Backcolor only addresses the area surrounding the click area, in other
words
where the text for the control is, as far as i can tell. Please tell
me
if i
am wrong. I am trying to address the area where the black point or
tick
appears when clicked.

Geoff

"Bob Phillips" wrote:

If you use controls from the Control Toolbox you can set the
backcolor
property

--
HTH

Bob Phillips

"Geoff" wrote in message
...
Hi

I posted this in the developers ng without response.

Anyone know what the centre or click areas of Option Buttons or
CheckBoxes
are called and how they can be addressed?

This is in the context of changing the backcolors of other controls
such
as
textboxes. These click areas seem to remain the same color as the
application colors set for Excel in the Display Panel and sometimes
stand
out
like a sore thumb against the rest of a form.

T.I.A.

Geoff

How about properties, BackColor?

RBS


"Geoff" wrote in message
...
Hi

I posted this in the developers ng without response.

Anyone know what the centre or click areas of Option Buttons or CheckBoxes
are called and how they can be addressed?

This is in the context of changing the backcolors of other controls such
as
textboxes. These click areas seem to remain the same color as the
application colors set for Excel in the Display Panel and sometimes stand
out
like a sore thumb against the rest of a form.

T.I.A.

Geoff