Fitting a checkbox into a cell

Hello,

Please help. I created a checkbox (from the Forms toolbar) and set it to the smallest size it would allow me (0.24" x 0.33") and set the Properties to "Move but don't size with cells".

I then positioned it above a cell. But, everytime I insert a row above the cell, the checkbox moves and gets resized.

What I'm trying to make is a checklist by putting a checkbox in every row of my list. What's the best way to do this?

Thanks.

[Dave Hawley]

I wouldn't use too many Controls as they can blow out file size for little return. Here is an alernative method that use the Marlett font and the letter "a" Just place it in the sheet in question, Right click on the sheet name tab, select "View Code" and paste in this

Option Compare Text
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B1:B20")) Is Nothing Then
If Target = "a" Then
Target = vbNullString
End
End If

If Target = vbNullString Then
Target.Font.Name = "Marlett"
Target = "a"
End If
End If

End Sub


This particular code will toggle a tick on/off in the range B1:B20 simply by clicking in the cell.

Wow. You've been a really big help.
Thanks, Dave Hawley.