Make CommandButton on userform appears grayd out

hmk

Active Member
Joined
Jun 8, 2004
Messages
423
Hi there

How to make a commandBottun on a userform appears not active(grayd out) untill certain action is performed, then the commandbar Bottun will be active(Not grayd out) ?
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Hi

You could either:
1) in the properties for the button on the form, change the enabled to false
or
2) use the userform_initialize code to change the enabled to false.

As part of the code accompanying the "action", you can then change the enabled from false to true.

HTH

Tony
 

Watch MrExcel Video

Forum statistics

Threads
1,118,535
Messages
5,572,754
Members
412,482
Latest member
arooshrana2
Top