Double click on a cell to add check mark?

robbinskelly7 · #1 02-09-2015, 04:19 PM

I was told there was a way to automatically add a check mark to a cell just by double clicking on it. Can anybody help?

excelledsoftware · #2 02-09-2015, 07:05 PM

Anything is possible. If you add this code to the worksheet module it should work. There other ways to do it without having to change the font to wingdings if you can live without a proper checkmark.

Insert this code by pressing Alt + F11 then double click the worksheet on the left and paste in.

Code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
  Target.Font.Name = "Wingdings"
  Target.Value = Chr(252)
End Sub

Another note. The doubleclick method cannot be undone so if you try to use CTRL Z it will not undo. Not a huge issue because it is just a checkmark but you may want to put in data validation in cells that you do want to change.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Files Won't Open With Double Click	ykhalil	Office	1	11-10-2014 05:00 AM
Check Box Form Field Book Mark Auto Fill?	zacam87	Word VBA	5	08-20-2014 02:56 PM
Play Shockwave on a double click	dedine	PowerPoint	4	06-03-2013 08:26 AM
Outlook .oft template - double-click creates new message but	Robarooney	Outlook	1	08-05-2009 11:10 AM
Cannot Double Click on Microsoft Word Document	weeleong87	Word	0	07-19-2009 05:54 AM