VBA Code to Gray Out Command Button on Userform

**riffology** · 08-01-2013, 02:37 PM

Hi Everyone,

This is my first post, so hopefully I do this right. Is there a way gray out a command button until a selection is made in the listbox of the userform and then make it available to click once a selection is made?

Thanks,

Jeff

**Norie** · 08-01-2013, 02:45 PM

Perhaps.

Please Login or Register  to view this content.

You'll also need to change the Enabled property of the command button in design view or with code.

**riffology** · 08-01-2013, 02:49 PM

Thanks Norie! This worked perfectly.

Jeff

VBA Code to Gray Out Command Button on Userform

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code to Gray Out Command Button on Userform

Re: VBA Code to Gray Out Command Button on Userform

Re: VBA Code to Gray Out Command Button on Userform

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] getting data from command button in userform why is my code not working?

[SOLVED] Excel vba userform - code for command button not working

Code a Command Button on UserForm not to close upon click - Excel VBA

Code for a master command button to change the backcolor of multiple command buttons?

Command button code to write to worksheet and then open userform

Bookmarks

Bookmarks

Posting Permissions