Userform questions !

[awsumchillicrab]

Hi,

I have a userform with some option buttons, a checkbox, labels, and some a "Run" command button. Here's what I want to do:

I want the "Run" button to be greyed out or somewhat unclickable unless the checkbox is checked and one of the option buttons selected.

When an option button is selected, I want the label to have different captions. At first, the label should be blank. If 1st button selected, it should be "ABC", and if 2nd selected, "DEF"...etc

And I can't seem to press enter in a labelbox (to get the cursor one line down in the same label box).

Any help appreciated!

 

[p45cal]

And I can't seem to press enter in a labelbox (to get the cursor one line down in the same label box).

Ctrl + Enter, not just Enter.

Regarding the rest, you'll have to use some event code, but it's involved. It may help if you can post the workbook with the userform populated with all the labels/buttons/optoin button etc. in the interweb somewhere (box.net?)

 

[awsumchillicrab]

Thanks! Got the ctrl enter

I managed to figure the rest using Events.
Curious though, is there a better way of doing it? For example, I have below:

Private Sub CheckBox1_Change()
If CheckBox1 = True And _
(OptionButton1 = True Or OptionButton2 = True Or _
OptionButton3 = True Or OptionButton4 = True) Then
CommandButton1.Locked = False
Else
CommandButton1.Locked = True
End If
End Sub

This code resides in an event of checkbox change, which is fine. But can I put this code in a more general space, without event triggers?

 

[p45cal]

But can I put this code in a more general space, without event triggers?

Yes.