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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkboxes and multiple cell values
Ingenius! Thanks
|
Reply |
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 |