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 |