Excel VBA - Beginner to PRO Masterclass with Code Samples

I think the nice thing about VBA is that the better you get Excel the better you get at VBA. Knowing that the built in Excel functions seems to lead to seeing more opportunities to use those as opposed to writing code to accomplish the same thing.

Hi chandoo. I just came to realise that since VBA does not work on the web I have a problem when ‘collaborating’ with my colleagues, as some of my workbooks have macros and VBA sub routines which render the collaborating ( or rather the use of these sub routines) useless. Is Office script going to replace these features ? I do not seem to clearly understand what features we can use ( in the cloud) to enable macros or automation straight from a ‘button’. Am I making sense ? Perhaps with so many new apps , etc etc
I am getting confused. Thanking u in advance. Regards. Martin

Sub markAsDone()
' This is a test code
Dim timenow As Date ' Declare the variable here

If (ActiveCell.Column = 4 And (ActiveCell.Row >= 5 And ActiveCell.Row <= 24)) Then
If ActiveCell.Value = "Done" Then
' Prompt the user to confirm overriding the entry
Dim response As VbMsgBoxResult
response = MsgBox("The cell already contains 'Done'. Do you want to override it?", vbYesNo)

If response = vbYes Then
' User chose to override
ActiveCell.Value = "Done"
timenow = Now ' Assign the current timestamp
ActiveCell.Offset(0, 1).Value = timenow
End If
Else
' Cell does not contain 'Done', mark it as 'Done'
ActiveCell.Value = "Done"
timenow = Now ' Assign the current timestamp
ActiveCell.Offset(0, 1).Value = timenow
End If
Else
MsgBox "You have selected the wrong cell"
End If
' Debug.Print (ActiveCell.Row)
End Sub

Sub markAsDone()
'this is a test code
If (ActiveCell.Column = 4 And (ActiveCell.Row >= 5 And ActiveCell.Row <= 24)) And ActiveCell.Value <> "Done" Then
ActiveCell.Value = "Done"

Dim timenow
timenow = Now
ActiveCell.Offset(0, 1).Value = timenow
End If
'Debug.Print (ActiveCell.Row)
End Sub

Thanks, great lecture!
Definitely wanna see a video about utilizing GPT for VBA coding! Also how to build “repetitive” Pivot Tables via VBA

From Somalia

yes

Awesome passion for you as a youth skilling leader. In this era, you're my mastery of tech areas.

Thank you for sharing knowledge

Hi Chandon,

*Face problem * that is it possible to join three Slicer table in excel worksheet.

I have try but not able to navigate the right process can you give u r insight on this .

India Delhi

Thank you, Chandoo, for all you do! Your videos are awesome. Your style is unique--it draws you into the conversation. You uniquely take topics that can be, well, boring, and create excitement. Your explanations are simple to follow and provide actionable advice for all to use in their daily job.

Flying the crow Chandoo is my bro. 😂❤❤❤ Love from Bangladesh.

Another WOW project of yours Chandoo! Many thanks!

Thank you. You are great bruh

'AWESOME !

thanks for this video

Hello from Germany

Also make video on how to teach! 🤝

Useless content there is no any information
If you teach make an video series of VBA

India, Hyderabad

Thanks for this, Chandoo. Mabuhay👊

Thanks chandoo for sharing your knowledge for all of us

I am not a programmer. Once I asked for help from a programmer to scrape and sort some data from a website. He did that for me. Fun fact is that his code took more time than my template (Excel+Some Formula+1 VBA). Just sharing my experience. Like Chandoo said "You will know when you need to use Excel or Python. Consider both just as tools."

Thank you for your contribution helping and educating us in many ways.

How to run ARS via VBA

Ravi jha delhi IND

Thanks for sharing valuable knowledge

Bro u waisted 12 mins of my time just looking at ur comments and time is prssious although ur making money from it so have consideration for others and get to the point.

Mumbai

India 🇮🇳

Southern USA😊

GREAT Chandoo

I am from saudi arabia, interested to learn Excel VBA

My best wishes to your family and children..... dear Poorna Chandu....

Hi Chandoo,

My best Birthday wishes and lots of love to your lovely kids.🎉🎉🎉

Have great 🎊celebration🥳

From Hyderabad.

Hi dear Chandoo, best regards from Limón, Costa Rica!

India pune

Colombia, South America!

Thanks for sharing, I follow you from ALGERIA

Happy Birthday to your children... they have got amazing parents......

Hello from Assam India

Rochelle Rowe from Jamaica

Are you going to do one on JavaScript for online Excel or one on Python that is now integrated into Excel?

Telangana, RAJANNA SIRCILLA District

Chala bagunnam bro

Hallo from Germany

👍

Yes