A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* active | api | Application | array | chart | clipboard | color | date and time | debug | Error | file | filter | find | format | log | loop | named range | PPT | Pivot Table | record | udf | workbook | wrapper Continue at Database_code 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills |
| • | Labels for Goto | |
| • | Large Arrays - Interview Question | |
| • | Large Nested-If with missing end if or Else statement | |
| • | Large Spreasheets | |
| • | Last_day_of_month | |
| • | Last_day_of_prev_month | |
| • | LatestVersion - udf | |
| • | LBDOM - dates - udf - Last Business Date of the Month | |
| • | LBound(array) - returns the lower bound of an array | |
| • | lcase | |
| • | lcol = Finddatacol("column header fields",1) ' avoid hardcoding by searching for a column | |
| • | Leading 0 problem and Excel hides it | |
| • | Learn by going from small to big | |
| • | Learn by using the Macro recorder | |
| • | Learn Excel and Extract data from the Web | |
| • | Learn Excel and Turn Ideas to Money | |
| • | Learn to Juggle | |
| • | Learn via Google | |
| • | Learn via Immediate Window | |
| • | Learn via Macro recorder | |
| • | Learn via sample code | |
| • | Learning by stepping through code🔝 | |
| • | Learning language at the new job | |
| • | Learning new things is stressful | |
| • | Left(sting,len) | |
| • | Len(string) - vba function | |
| • | LenB() - vba function | |
| • | Level of Understanding | |
| • | Line Input #x, sData | |
| • | List of Options to Be Familiar With | |
| • | List of terms to know | |
| • | List of Windows Controls or Objects to be Familiar With | |
| • | Load cell value to a vba variable | |
| • | Load_Collateral_values_toDB | |
| • | LoadArray(workbookname, Sheetname, header) 🔝 | |
| • | LoadData(sFile) - udf - loads a file's data to a string | |
| • | LoadFileToString(sFile) - udf | |
| • | LoadListBox(c as object, sSQL as String) - db - udf - | |
| • | LoadQueryToString - udf - db | |
| • | LoadSQLtoSheet | |
| • | Log2File udf | |
| • | LogAction - udf to write 3 fields to a sheet | |
| • | Logautorun - udf | |
| • | Logger - user defined shortcuts | |
| • | Logit | |
| • | logit2(s) ' writes data to sequential file ' udf | |
| • | LogSQLError - | |
| • | LogWaitTime - track time my machines is unavailable due to PPT code running | |
| • | Loop | |
| • | Lower case/upper case bug | |
| • | LTrim - VBA func |