View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] CraigRichardPhillips@gmail.com is offline
external usenet poster
 
Posts: 6
Default Checkboxes and multiple cell values

Hey all,

When clicking a checkbox in a userform, I'd like that checkbox to place
two X's in two different cells. I'm sure this is basic, but isn't
there an "AND" statement in VBA?? Something like:

Range("A31").Select

If ckbSFD = True Then

ActiveCell.Value = "X"

And

ActiveCell.Offset(1, 23).Value = "X"

End If

If I can get this code down, the rest will fall in place.

Thanks!