Cell Height containing Checkbox

[prh26]

Hi Everyone. This is the first forum I've ever been on and this is my first post, so please let me know if I need to provide more details than below.

I'm using Excel 2007 and have a spreadsheet with numerous columns. All of cells in the columns are wrap enabled. The 2nd column on the sheet has a checkbox which is unchecked...but then has to be checked once an that line item is complete (it's for invoicing work orders).

My Issue: when any of the columns have to wrap due to the amount of text entered, the checkboxes tend to get jumbled and more than one checkbox ends up in the same cell. They almost act like clip art.

Does anyone know how to change how the checkbox behaves? I'm trying to get one checkbox per cell in a particular column...no matter what the height.

Thank you for reading this and helping

-prh26

 

[mitster]

did you do this with code or by the toolbox feature?

 

[prh26]

Toolbox feature under the Developer Tab.

 

[mitster]

the best way to go about creating checkboxes would be by code especially if your making alot of them. right click the sheet tab your working on and click View Code, paste the following code in the window, modify the cell range and run it by pressing F5. try it out on a blank sheet first to get the feel for it.

Sub ADDCHECKBOX()
Dim cell As Range
For Each cell In Range("b2:b8")
With ActiveSheet.CHECKBOXES.Add(cell.Left, cell.Top, cell.Width, cell.Height)
.LinkedCell = cell.Offset(, -1).Address(External:=True)
'.Interior.Color = RGB(80, 150, 220) 'or xlNone or xlAutomatic
.Display3DShading = True
.Caption = ""
.Border.Weight = xlThin
.Height = 17
End With

Next

End Sub

 

[prh26]

Thank you so much Mitster! The code worked perfectly!