View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] idyllicabyss@googlemail.com is offline
external usenet poster
 
Posts: 32
Default Checkboxes and multiple cell values

What's wrong with;

If ckbSFD = True Then
Range("A31").value = "X"
Range("B54").value = "X"
end if

and placing it into the Click_event of the checkbox or into the code of
a button that is clicked once the UserForm or whatever has been filled
in.