Data Access - VBA Functions

00:00:00 Start
00:01:00 QueryIt spreadsheet - using Excel functions in VBA
00:02:00 WorksheetFunction. (run-time error) vs Application. (allow VBA to handle errors inline using IIF)
00:03:46 Example of calling Excel functions and handling errors - Polaris JSON_Parser function
00:06:44 VBA built-in functions used to manipulate text - Instr/InstrRev, Replace, Like operator, IsNumeric, Ucase, Lcase, Chr, Format, .CurrentRegion.Rows.Count, Split (discussed with CSV_Splitout)
00:09:37 VBA comparison operators, Replace, Instr, and Like are CASE SENSITIVE when string comparison method is default Option Compare Binary
00:11:14 VBA built-in functions Msgbox, InputBox, Application.StatusBar
00:15:31 Conditional statements - IIF (In-line If), IF (single statement syntax, multiple statement syntax, ElseIf syntax), and Select Case (use as In clause)
00:16:37 Polaris provided functions - UpdateTime, ColNum, ColLetter, TransposeArray (use instead of Excel Transpose), XIRR_Short, Random
00:20:05 Other Polaris provided functions - MaxArr, MinArr, MearArr, Stdev_Arr, ChartScale, LastRow_InColumn, DistinctSort
00:21:58 Additional Polaris provided functions - IfBlank, WorksheetNameExists, WorksheetIndexExists, TabNum, TabName, ActiveTabName, Indirect_Trigger
00:24:56 CSV_Splitout code walk-through
00:26:37 VBA way to determine number of instances of substring in text - uses UBound and Split VBA functions
00:27:40 JSON_Parser code walk-through
00:29:45 VBA Math function Round
00:30:08 VBA For Next Loop - looping with decimal numbers
00:34:55 Array typing - Variant, User Defined Type (UDT), String
00:40:18 Wrap-up

Видео Data Access - VBA Functions канала Polaris Investing