View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark \(InWales\)[_17_] Mark \(InWales\)[_17_] is offline
external usenet poster
 
Posts: 1
Default tick boxes on userforms

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