Hi Chaplain Doug,
What I really need (or want) to do is have every cell in a particular
column be a checkbox. How may I accomplish this?
Using VBA, try:
'=============>>
Sub InsertCheckBoxes()
Dim rng As Range
Dim c As Range
Set rng = Range("A1:A20") '<<====== CHANGE
Application.ScreenUpdating = False
For Each c In rng.Cells
With ActiveSheet.CheckBoxes.Add(c.Left _
+ 5, c.Top - 2, 5, 5)
.Caption = ""
.LinkedCell = c.Address(False, False)
End With
c.Font.Color = vbWhite
Next c
Application.ScreenUpdating = True
End Sub
'<<=============
Change ("A1:A20") to your range of interest.
If you are not faniliar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm