How to choose only three windows?

really good explained thank you:)

Thank you mate. I'm just getting know to R for my future Data Analyst job and I trried to figure out how to move the console on top of a screen.

How to keep the Toggle Button ON even if I close userform and re-open it again, stays with ON pressed?

great VBa videos ..noticed you etopped...hope all is well

At 6:37 The sheets get added as 10 9 8, is there a way to make the sheets appear as 8 9 10 in numerical order from lowest to highest instead of highest to lowest

😍😍😍😍

Thank you❤️😍😍

Thank you for this! I am stuck and wondering if anyone can assist! Once you have your toggle and everything set up, how can I use a reset button I've added to reset all my toggle buttons (20 of them) to their default which hides all the sections they show/hide?

Excellent Playlist. Thank you! Subscribed.

Isnt your pace a bit too slow?

Thanks a lot, I've tried it in this way and it works too. Sub Test() Dim rng As Range Dim endcell As String Dim clr As Long Dim rcell As Range Dim d As Integer Dim a As Integer Dim b As Integer Dim e As Integer Dim c As Integer Dim i As Integer endcell = Range("b2").End(xlDown).Row Set rng = Range("b2:b" & endcell) If Range("A2") = "" Then endcell = "2" rng.Interior.Color = xlNone clr = 1000 For Each rcell In rng d = Range("b2").Row b = rcell.Row e = rcell.Row - 1 For c = d To e If rcell.Value = Range("B" & c) And rcell.Offset(0, -1).Value = Range("B" & c).Offset(0, -1).Value And rcell.Offset(0, 1).Value = Range("B" & c).Offset(0, 1).Value Then b = 1 Next c a = b + 1 For i = a To endcell If rcell.Value = Range("b" & i).Value And rcell.Offset(0, -1).Value = Range("B" & i).Offset(0, -1).Value And rcell.Offset(0, 1).Value = Range("B" & i).Offset(0, 1).Value Then Union(rcell, rcell.Offset(0, -1), rcell.Offset(0, 1), Range("b" & i), Range("B" & i).Offset(0, -1), Range("B" & i).Offset(0, 1)).Interior.Color = clr Next i clr = clr + 1000000 Next rcell End Sub

Pivots via VBA is really hard. I also haven't figured out the difference between TableRange1 and TableRange2

Fantastic explanations of for each you are giving us. :D Must be tiring for you to move around all the time with your mouse

Hi sir, I get an error when I run the following line: Dim var_Integer As Integer 'this can store numbers - 32.768 to 32.767 -----> 2 Bytes of Memory var_Integer = 5.6 'MsgBox(var_Integer) 'WARNING IMPLICIT ROUNDING wants snow 6 I get the following message: Compiling Error: Duplicate declaration in the current range This part of the line is reported as error: var_Integer As Integer What am I doing wrong?

Excellent. Maybe you can do something where you don't need to keep moving around so much in excel

Hi, too bad I can't see what you've copied, too bad I'm trying to do the same, that way so I can learn something, or is all of that unnecessary?

it's a lot of work on your side to create this, and it's free for us. thank you for this. you do a great job at explaining

Sorry i dont understand why they're being referred to as modules when they appear to be objects due to the fact that they're listed under a folder named Microsoft Excel Objects, not Modules.

I like your motivation and excitement. Best thing to add to my idea box

Great work! Very well explained it. Made it so easy to understand such heavy concept. Thank you very much!

Great video

thx

The problem i am having is that the empty rows i have are zero value based on formula. so , when i ma using the code , its deleting every thing. any advise. My 1st row is row 8 this is the code i am using Sub Delete_Rows() Dim lastrow As Long, xrow As Long xrow = 8 lastrow = Range("a400").End(xlUp).row Do Until xrow = lastrow If Cells(xrow, 8).Value = "" Then Cells(xrow, 8).Select Selection.EntireRow.Delete xrow = xrow - 1 lastrow = lastrow - 1 End If xrow = xrow + 1 Loop End Sub

Thank you. But one question, if I assign a constant, e.g. Const NameOfVariable As Integer = 9, when I insert a breakpoint before that line, the local window still shows the NameOfVariable with the value of 9 (it should be 0 given that the code stops before getting to NameOfVariable code line). Is this an exception for constant?

Great video!

Great Sir....Please keep the code at last in one frame of camera so that we can take picture for our reference and practice it.

i know python, in my current position is so hard to get approved for python. so i turned to VBA to automate sanity checks. i've been googling every syntax. but as long you have some experience in any other language would make it easy to learn new programming languages. these videos come handy i can't thank you enough. good job budd

Great cours !

Thanks for the thorough explanation of how the code actually works.

"It is September right now" *uploads in February* I feel like I missed something.

Excellent instruction! Thanks a lot!

Is this file still for sale?

Are you still making videos?

I think I found Bill Burr’s brother! Sounds like him, am I picking up a bit of a Boston accent there? 🤔🤔🤔🤔🤔🤔🤔🤔🤔🤔🤔!!!!

These are my best binge worthy videos. These are helping me a lot.

cool

i'm exactly the 20,000 viewer,,, very good...

Excellent work. Highly recommended to launch website and award certificate for subscribers as well upon completion.

Not sure how it works. When I go to the library, "ActiveSheet" is not a member of "Worksheet" class. Why can we write WorkSheet.ActiveSheet.name? "ActiveSheet" is actually a member of "Workbook" as shown in the library. But if I programme it as Dim ws As Workbook Set ws = Activesheet There is an error message

I really like your mistakes, I have just three amount of knowledge to recognize you made a mistake and it lets me think about the consequences, giving me a better understanding of how it works.

God bless you

The best part is that it is of Goldilock type lecture which lets all to understand it.Thanks 🙏

Nope. Can't be doing with the constant throat clearing, ums and ers.

Thanks so much!

You are such a great teacher. This much keen attention to detail is an extreme rarity. You deserve to be a prof in the Ivy League colleges. You must definitely be having a genius IQ for being able to understand every possibility and simplify it

Thanks! For 64bit machines: Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

excellent channel, the skills I got through your channel a few years ago got me my last 2 jobs

third

Easy to understand, nice playlist! Thanks