Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
adding multiple checkboxes in a single cell | New Users to Excel | |||
adding multiple checkboxes in a single cell | New Users to Excel | |||
Creating multiple checkboxes in a cell | Setting up and Configuration of Excel |