View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Dim Userform Control

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