Is there an easy bit of code for dimming a UserForm Control when not in use?
--
donwb

I'm not sure what you're after, perhaps more detail would be
helpful. But you can declare a variable of a control's type with
code like

Dim MyComboBox As MSForms.ComboBox
Set MyComboBox = UserForm1.ComboBox1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"donbowyer" wrote in
message
...
Is there an easy bit of code for dimming a UserForm Control
when not in use?
--
donwb

You are probably looking for the enabled property.

CommandButton1.Enabled = False
--
HTH...

Jim Thomlinson


"donbowyer" wrote:

Is there an easy bit of code for dimming a UserForm Control when not in use?
--
donwb

Your answer is probably what the user wanted. I took "dimming" to
mean using a Dim statement, not the more obvious "making
something dim". My mistake.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jim Thomlinson" wrote in message
...
You are probably looking for the enabled property.

CommandButton1.Enabled = False
--
HTH...

Jim Thomlinson


"donbowyer" wrote:

Is there an easy bit of code for dimming a UserForm Control
when not in use?
--
donwb

There is a problem with UserForm SpinButtons in that they can be disabled
like that but they won't look disabled.

Will have to do as well:
ForeColor = vbButtonShadow

RBS


"Jim Thomlinson" wrote in message
...
You are probably looking for the enabled property.

CommandButton1.Enabled = False
--
HTH...

Jim Thomlinson


"donbowyer" wrote:

Is there an easy bit of code for dimming a UserForm Control when not in
use?
--
donwb

I'm not now sure I can do what I thought I could do ie dimming (less bright)
a TextBox. But one of your suggestions - set it to active=false will do fine.
Thanks everyone
--
donwb


"donbowyer" wrote:

Is there an easy bit of code for dimming a UserForm Control when not in use?
--
donwb