20 Essential VBA Functions Every Programmer Should Know

In this video, we cover 20 VBA functions that every budding macro programmer should be familiar with, along with a code sample for each. The functions are:
MsgBox, InputBox, Left, Right, Len, UCASE, LCASE, Join Function, IsNumeric, Sheets.Add, Range.Copy, Range.Insert, Worksheet.Paste, GetOpenFilename, Workbooks.Open, Workbook.Save, Workbook.Close, Application.Calculate, Application.Quit, Application.WorksheetFunction.
#excel #macro #vba

[@nIghtorius]

With the sheets macro. I would have done the following if statement:
If IsNumeric(NumberToAdd) And NumberToAdd > 0 then
Using >0. You don't want to have negative values there.

[@syntaxbyte]

Good eye, thanks.

[@mr.write1433]

Quality of your video too low. Cant even see if what is written