text boxes and check boxes in frames in VBA

[VBAmalta89]

I have a user form which has 8 frames. The user selects how many of the frames to activate by means of a text box.

Within each frame are a list of check boxes, adjacent to which are text boxes. What I would like to do is to have all text boxes inactive until the user checks the adjacent check box of each text box.

Is this possible?

 

[doofusboy]

Yes it is possible. One way to do it would be to disable the textboxes during development of your form and then adding some code like this:

Private Sub CheckBox1_Click()
    TextBox1.Enabled = True
End Sub
Private Sub CheckBox2_Click()
    TextBox2.Enabled = True
End Sub

 

[VBAmalta89]

thanks ill give it a go.

 

[doofusboy]

You can set their enabled property to false in the IDE or you can do it view code when the form is initialized like this:

Private Sub UserForm_Initialize()
    TextBox1.Enabled = False
End Sub

 

[VBAmalta89]

will this work even though i hve a varying amount of frames being activated?

 

[doofusboy]

You control which ones are enabled or disabled via code just as I showed in previous post.

 

[VBAmalta89]

my problem is that when the user enters the number of frames to activate, the text boxes within the frames are being enabled prior to checking their adjacent check boxes!

 

[doofusboy]

And I have already told you how to solve that problem, you need to either disable the textboxes during design time in the IDE or via code when the form is initialized.

 

[VBAmalta89]

I did that thats why i had to post again to tell you that for some reason they wer being enabled again wen the user enters the number of frames to activate as i explained in the previous post

 

[doofusboy]

Then try disabling the textboxes in the same place the frames are being enabled.