Microsoft Office Forums Double click on a cell to add check mark?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2015, 04:19 PM
robbinskelly7 robbinskelly7 is offline Double click on a cell to add check mark? Windows 7 64bit Double click on a cell to add check mark? Office 2013
Novice
Double click on a cell to add check mark?
 
Join Date: Feb 2015
Posts: 2
robbinskelly7 is on a distinguished road
Default Double click on a cell to add check mark?


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?
Reply With Quote
  #2  
Old 02-09-2015, 07:05 PM
excelledsoftware excelledsoftware is offline Double click on a cell to add check mark? Windows 7 64bit Double click on a cell to add check mark? Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 453
excelledsoftware will become famous soon enough
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Double click on a cell to add check mark? 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
Double click on a cell to add check mark? 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


All times are GMT -7. The time now is 10:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft