Command Button disabled until checkbox selected

**JamesT1** · 12-06-2013, 04:58 AM

Good Morning Folk

I have a userform that will open when the workbook opens. It has two checkboxes and a command button. I am looking for the command button to be disabled until one of the checkboxes is selected.

The checkboxes are working ok however the command button is enabled at all times and selecting it without selecting a checkbox throws up an error in the 'cmdenter.Enabled = False' line

This is the code I have so far, can someone point out where I have went wrong,, many thanks

Please Login or Register  to view this content.

Many thanks for your help

**mehmetcik** · 12-06-2013, 05:20 AM

Seems bit complicated, At the top of the Command Box Click event. Test for the option button and exit.

Please Login or Register  to view this content.

**JamesT1** · 12-06-2013, 05:54 AM

mehmetcik

Many thanks for the advice,, it now works... I removed the other code and adjusted the code for the command button to include the two lines for the check boxes....

much simpler now...

Please Login or Register  to view this content.

**mehmetcik** · 12-06-2013, 10:35 AM

You have one if statement too many

Please Login or Register  to view this content.

Command Button disabled until checkbox selected

LinkBack

Thread Tools

Rate This Thread

Display

Command Button disabled until checkbox selected

Re: Command Button disabled until checkbox selected

Re: Command Button disabled until checkbox selected

Re: Command Button disabled until checkbox selected

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Command button grayed out till option button selected

clearing a checkbox wth command button

Command Button to clear checkbox

Checkbox choices that run code on clicking command button

deleting a row with checkbox and command button

Bookmarks

Bookmarks

Posting Permissions