View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dmoney Dmoney is offline
external usenet poster
 
Posts: 42
Default 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


.