#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
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 Thanks |
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 |