Excel VBA Userform checkbox questions

Question

Is it possible to make it so that if a check is put in a check box that certain fields of the form are made so that the user cannot add data?

Form is asking for address, city, state, zip

Checkbox asks if the person is homeless

So wanting to make it so that if there is a check in the box that address info cannot be entered.

Else... if there is data in the address fields AND the box is checked that an error appears on the screen.

Help.

T.M. · Accepted Answer · 2019-04-07 08:09:59Z

1

An example could look like that.

Private Sub chkHomeless_Click()
    If chkHomeless.Value Then
        With txtCity
            .Value = ""
            .Enabled = False
        End With
        With txtState
            .Value = ""
            .Enabled = False
        End With
    Else
        txtCity.Enabled = True
        txtState.Enabled = True
    End If

End Sub

You would need to add the code for the third TextBox and you might want to add a kind of Question if the textboxes should really be emptied when checking the box. Or you display in this case a kind of error message as you wrote in your post.

edited Apr 7, 2019 at 8:09

T.M.

10k3 gold badges40 silver badges61 bronze badges

answered Apr 7, 2019 at 6:34

Storax

12.7k3 gold badges21 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel VBA Userform checkbox questions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related