Alright I found an old post using VB. It creates a check box but now how do I condition it to move the 4 cells "C1,C2,C3,C4" to 4 specific cells on another worksheet? Here is the code I found
I'm not sure if this will help, but I use this code (I did not make it). It creates a checkbox automatically for you. Very nice, not a standard checkbox design, plus it highlights the background in yellow, so it's very visible when you're using a lot of checkboxes. It will put a true or false in the cell that the checkbox rests above. So you can then use a range formula to add the true/false statements.
Not sure if this helps you or not.
To use:
Go to Tools>Macro>Macros>type a name (chckbxmkr) then click Create.
Paste this code, exit VB.
Select as many cells on your worksheet as you want, run this, and sweet little checkboxes will appear above every cell you have selected.
"Andrew's Excel Tips" is where I got this from.
I take no credit.
Good luck,
Teacher Eric
---------------
Sub chckbxmkr()
On Error Resume Next
Dim c As Range, myRange As Range
Set myRange = Selection
For Each c In myRange.Cells
ActiveSheet.CheckBoxes.Add(c.Left, c.Top, c.Width, c.Height).Select
With Selection
.LinkedCell = c.Address
.Characters.Text = ""
.Name = c.Address
End With
c.Select
With Selection
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, _
Formula1:="=" & c.Address & "=TRUE"
.FormatConditions(1).Font.ColorIndex = 6 'change for other color when ticked
.FormatConditions(1).Interior.ColorIndex = 6 'change for other color when ticked
.Font.ColorIndex = 2 'cell background color = White
End With
Next
myRange.Select
End Sub
Please Help!
Thanks!
Briana
