20 Essential VBA Functions Every Programmer Should Know
Vložit
- čas přidán 4. 09. 2024
- 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
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.
Good eye, thanks.
Quality of your video too low. Cant even see if what is written