Turning a cell into a check box

Hi everyone, I was wondering if there was a way to turn a cell into a check box as opposed to putting a check box into the sheet by selecting one from the forms toolbar.

Yes, the Ö becomes a check if the font is symbol.

Enter this code into your worksheet (right click on the tab and select "view code")

Please Login or Register  to view this content.

It will put a checkmark in whatever cell you doubleclick on (so be careful where you double click)

ChemistB

Thanks VBA!
I need to tidy up my macro skills.

ChemistB

Thanks for the help guys!

I never knew you could code spreadsheets this way.

How would I modify this code to target only specific cells that are double clicked?

How about to remove the check mark if double clicked again?

Sorry abut that I have been used to submitting my questions directly to the original posters thread, did not realize it was done differently here, I was in a rush at the time of posting, I wil create my own thread, sorry for any rule violations.

Thanks

Originally Posted by FDibbins

MilsonHQ welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.