tick boxes on userforms

  • Thread starter Thread starter Mark \(InWales\)
  • Start date Start date
M

Mark \(InWales\)

Hello All

I have a userform with an array filled ListBox. What I am trying to do is
set the CheckBox value to true if the item in the array has a total
associated with it. So if you select item1 in the ListBox and enter a total
via a TextBox for item1 then CheckBox1=true assuming the user doesn't exit
the UserForm.

Any help would be greatly appreciated especially if this could be done using
a loop instead of adding each checkbox and the associated If statements!

Mark
 
u can check for and set the checkbox's desired condition
with the textbox change event for exmpl:

Private Sub TextBox1_Change()
If TextBox1.Value <> "" Then
CheckBox1.Value = True
Else: CheckBox1.Value = False
End If

End Sub
 
Thanks DMoney for your help
DMoney said:
u can check for and set the checkbox's desired condition
with the textbox change event for exmpl:

Private Sub TextBox1_Change()
If TextBox1.Value <> "" Then
CheckBox1.Value = True
Else: CheckBox1.Value = False
End If

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top