Hi Sumit.. great video on methods and techniques for adding check marks. I especially like your VBA double-click method.. super useful! Thanks for sharing your knowledge. Thumbs up!
@trumpexcel5 жыл бұрын
Glad you found the video useful Wayne
@jabieu32412 жыл бұрын
✓
@llghostll2254 Жыл бұрын
Can I use symbols for attendance then change it to a value when you add all the ticks up using countif? If anyone understands this let me know
@BuiEeyore Жыл бұрын
Very clear and comprehensive video! Thank you!
@prolificent Жыл бұрын
Great Video!
@kmharvey802 жыл бұрын
found the video in your website, came to YT to like it! Thanks so much!
@House03993 жыл бұрын
Thank you for this video. Your method is very simple and elegant . Thank you for your help.
@tamfrager3 жыл бұрын
Thanks! I was looking for the VBA double-click code. I tried something I found elsewhere, but it didn't work. Yours did. Appreciate it!
@kristyphan86764 жыл бұрын
The VBA was so easy and helpful and exactly what I needed! Thank you :)
@jrb64343 жыл бұрын
Very informative. Thank you!
@snehasekar37503 жыл бұрын
This is amazing!!! Thank you so much 🔥
@PreetiPrasad20145 жыл бұрын
Awesome ways
@russgrand-scrutton49824 жыл бұрын
Hi Suet, I also think this is a great video. Is there a way to write a VBA Code that would enable you to do the double click check marks in two separate column cells like column A cells and column B cells on the same spreadsheet?
@virilerex3 жыл бұрын
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 'Checking whether target cell is in third column If Target.Column = 4 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Marlett" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "a" Else Target = "" End If End If If Target.Column = 5 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Marlett" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "a" Else Target = "" End If End If If Target.Column = 6 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Marlett" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "a" Else Target = "" End If End If If Target.Column = 7 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Marlett" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "a" Else Target = "" End If End If If Target.Column = 8 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Marlett" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "a" Else Target = "" End If End If If Target.Column = 9 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Marlett" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "a" Else Target = "" End If End If If Target.Column = 10 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Marlett" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "a" Else Target = "" End If End If If Target.Column = 11 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Marlett" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "a" Else Target = "" End If End If End Sub Here! I was looking for the same thing and I had to find my own solution! Column D to Column K was my target, so as you can see I changed the first target to 4 which is D and I modified the code. I hope this will help!
@chiranjitsingh5255 жыл бұрын
Please make a detail video on interpolation & double interpolation in excel.
@VasanthKumar-hb7ke4 жыл бұрын
Thank you so much Dear :) Learnt a lot in this video :)
@MrDetteh2 жыл бұрын
It is just a step forward. Never backward.
@jag7051 Жыл бұрын
Hi Great stuff, can this also be done in word, if we have table
@hazemali3825 жыл бұрын
many Thanks ♥
@itsshaqq3 жыл бұрын
Nice
@RM123112 жыл бұрын
thanks sir
@TN_GAMING_007 Жыл бұрын
Insert a Check Mark (Tick ✓)
@kjdouglas224 жыл бұрын
Is there a way to do the vba in different columns on the same spreadsheet?
@virilerex3 жыл бұрын
check my answer pls!
@samipiyash93225 жыл бұрын
great
@shanithomas13474 жыл бұрын
How do you modify the VBA code to insert the checkmark in specific multiple cell ranges like 3rd cell in 1st row and 9th cell in 10th row.
@llghostll2254 Жыл бұрын
So I made a attendance sheet however I used the ticks but to put into a formula to get sums on the attendance am having issues
@devendrabain77485 жыл бұрын
Sir i really appreciate all the seaven methods of creating the check box and check marks But till the end of the video i was try to learn how to make empty check box which can be check marked ☑️ or cross marked ❎ in a single click. Please Help
@trumpexcel5 жыл бұрын
This can't happen with a checkbox, as it only has the option to check or uncheck. You can do this with the VBA method though, where you double click once and it shows the checkmark and you double-click again and it shows the cross mark (like a toggle). You will have to change the VBA code for it though
@devendrabain77485 жыл бұрын
@@trumpexcel Thanks sir, You are amazing. 👌👌👌👌 If it is possible for you please make video on this too. Else, though i am not good in VBA coding i need to try this my own
@trumpexcel5 жыл бұрын
Use the below VBA code for this: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 2 Then Cancel = True Target.Font.Name = "Wingdings" If Target.Value = "" Or Target.Value = "û" Then Target.Value = "ü" Else Target.Value = "û" End If End If End Sub
@tihomir4ototo3 жыл бұрын
@@trumpexcel How to make all, or specific cells to be able to do this. I can't manage the targer area...?
@fortinovargas49993 жыл бұрын
@@trumpexcel LO LO LO LO P PP ..
@p.narasimamurthy53535 жыл бұрын
How to import data multiple excel files data containing empty cell of every below cell in to power query plus sir
@redhaakhund12712 жыл бұрын
👍👍👍👍👍🏆
@trickstters4 жыл бұрын
Epic
@virilerex3 жыл бұрын
Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 'Checking whether target cell is in third column If Target.Column = 4 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Wingdings" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "ü" Else Target = "" End If End If If Target.Column = 5 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Wingdings" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "ü" Else Target = "" End If End If If Target.Column = 6 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Wingdings" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "ü" Else Target = "" End If End If If Target.Column = 7 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Wingdings" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "ü" Else Target = "" End If End If If Target.Column = 8 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Wingdings" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "ü" Else Target = "" End If End If If Target.Column = 9 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Wingdings" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "ü" Else Target = "" End If End If If Target.Column = 10 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Wingdings" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "ü" Else Target = "" End If End If If Target.Column = 11 Then 'Prevent cell going into Edit Mode Cancel = True 'Changing font type of the cell Target.Font.Name = "Wingdings" 'Checking if target cell value is blank then inserting tick If Target = "" Then Target = "ü" Else Target = "" End If End If End Sub
@virilerex3 жыл бұрын
I have modified the code to work on columns from D (4) to K (11), if you need something like this, i hope this will solve your problem.
@olerius12354 жыл бұрын
✅✅✅✅✅✅✅✅✅✅✅✅
@sparedcolt32242 жыл бұрын
Why is this video 17 mins. I just need to know how to put a check mark in. Should take 2 mins. Max.
@purpleshep38663 жыл бұрын
✓ ✓ ✓ ✓ ✓ ✓
@ffmalayali67842 жыл бұрын
Hlo
@russgrand-scrutton49824 жыл бұрын
Russ
@mahindapeiris82903 жыл бұрын
Hi Suet, I also think this is a great video. Is there a way to write a VBA Code that would enable you to do the double click check marks in two separate column cells like column A cells and column B cells on the same spreadsheet? 1