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 |
| • | fdom - first day of month -date udf | |
| • | File suffix - zip, xlsb, txt, xls, xlsx, xlsm, pdf, htm, html | |
| • | File wildcard character * or ? | |
| • | FileCopy from, to | |
| • | FileDateTime(sFileName) | |
| • | FileLen(sFile) - gets the length of the file | |
| • | FilesSystemObject.CopyFile sfrom, sTo | |
| • | FileToMD5Hex - internet - security | |
| • | FileToSHA1Hex - internet - security | |
| • | Fill Down | |
| • | Filter Problems copying moving... | |
| • | Filtering and visible rows | |
| • | Filters | |
| • | Final Else | |
| • | Find Missing Data | |
| • | FindDataCol - udf - 🔝 | |
| • | FindDataCol("fieldname",row_nbr) udf | |
| • | FindDataRow("string",col_nbr) | |
| • | FindDataRowPartial(sSearch, c) as Long | |
| • | Finding the Macro being Recorded | |
| • | FindLastCol(1) - find the last column passed a row udf | |
| • | Findlastrow - udf - finds the last row in a column | |
| • | FindWorkbook(sWB) udf | |
| • | FinishDEReport - udf | |
| • | FixEmail - Take an email address with < > and remove this | |
| • | FixName - takes a passed name in Last, First and changes to First Last | |
| • | FixTop25Other - a fix routine fixes something might have a small difference between version and standard | |
| • | FixXYZFormat - the format of data needed to be fixed to a format that the code could process | |
| • | Flashing while VBA is running | |
| • | Folders | |
| • | Footer | |
| • | For each (loop) item in collection | |
| • | For each shp in PPT.ActivePresentation.Slides(2) | |
| • | for i = 0 to rs.Fields.Count - 1 | |
| • | for i = Lbound(a) to UBound(a) | |
| • | for k = 1 to 12 step 3 ' loop | |
| • | For loop - lbound ubound | |
| • | For Loop with Birthday Problem | |
| • | for z = len(sSQL) to 1 step -1 | |
| • | Forecast Sheet | |
| • | format | |
| • | Format dates | |
| • | format(lVersion,"000") | |
| • | format(n,"#,##0") | |
| • | Formatcols - | |
| • | FormatFromTemplate - udf Report Engine | |
| • | FormatMultipleSheets udf | |
| • | FormatPrettyPrint | |
| • | formatting routines - almost all are recorded and modified | |
| • | FormatXyz - udf - to format data usually via recorded code, | |
| • | Formula Bar | |
| • | Formula error =A1-B1/2 | |
| • | Formula Error =C3-C2 and C2 is blank (if needed) | |
| • | Formula vs. Value vs. Format | |
| • | fr = Range("first_row").Row | |
| • | Freefile | |
| • | Freeze Frame Problem | |
| • | frm...show | |
| • | frmLogger.show 0 | |
| • | ftp | |
| • | Function | |
| • | Function returning a value | |
| • | functions vs. Sub |