Is there a way to insert/make a checkable checkbox in excel?

[ty1er]

Is there a way to insert/make a checkable checkbox in excel?

I just want to add a BOX at the begining of each Row that i can either Check, or click it again to UnCheck it. Is this possible.

I do know that i could just insert the Checkbox from the Wingding font. But im just looking for something that would be interactive by clicking it.

thanks.

 

[Concillian]

View --> Toolbars --> Visual Basic

Choose 'Control Toolbox'
Click on 'Enter Design Mode'
Click on the checkbox, then select the location in the woksheet where you want it and drag to the desired size
click the 'Exit Design Mode' button to make it functional (it will show/remove the checkmark, but you haven't linked the box to anything, so it won't actually do anything)

If you ever want to change/move/resize it you need to 'Enter Design Mode'

 

[ty1er]

Originally posted by: Concillian
View --> Toolbars --> Visual Basic

Choose 'Control Toolbox'
Click on 'Enter Design Mode'
Click on the checkbox, then select the location in the woksheet where you want it and drag to the desired size
click the 'Exit Design Mode' button to make it functional (it will show/remove the checkmark, but you haven't linked the box to anything, so it won't actually do anything)

If you ever want to change/move/resize it you need to 'Enter Design Mode'

Excellent! that was what i was looking to do!

thanks!
-ty1er