Top 10 VBA Tips and Tricks to Learn in 2022 - Excel Macro Coding

In this video, we will learn to Top 10 VBA Tips and Tricks that can help you to get the started with the your coding journey in Excel.

//Video Content Index//
Introduction 0:00
1. Create a Input Box (0:29)
2. Enter Current Date and Time (2:57)
3. Concatenate Two Values (4:45)
4. Sum Values from a Range (7:37)
5. Delete an Excel File (9:41)
6. Using With Statement (11:28)
7. Run a Macro on Opening a File (13:11)
8. Rename a Sheet (14:48)
9. Create a Named Range (16:27)
10. Rename an Excel File (19:35)

---------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------

#VBATips #VBATipsForBeginners

[excelwithmark]

great tips love VBA. Never knew about the kill function thanks for educating me

[WDRM]

Since you can't get time with the date keyword, an additional example of formatting the date and time would have been nice to have in this video.
Something like Range("b3") = Format(Now, "mmm-dd-yyyy hh:mm:ss AM/PM")

[NaveenKumar-srff]

Good evening, 5 min, 15 min, 30, min, 1 hr- me at a time VBA recording kaise kare, video baneye plz