Fitting a checkbox into a cell

G

Guest

Guest
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.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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.
 
Upvote 0

Forum statistics

Threads
1,213,492
Messages
6,113,967
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top