tick boxes on userforms
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
-----Original Message-----
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
.
|