Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-09-2015, 04:19 PM
robbinskelly7 robbinskelly7 is offline Windows 7 64bit Office 2013
Novice
 
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 Windows 7 64bit 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
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


All times are GMT -7. The time now is 09:21 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft