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 |
| • | format | |
| • | Date formatting yyyy-mmm-dd | |
| • | cl - udf - converts a # to the AA format | |
| • | (xxx) to convert to proper format - cok ?? | |
| • | Activecell.formula | |
| • | Value vs. formula | |
| • | Selection. (formula, copy) | |
| • | Activecell.formulaR1C1 = .... - code from macro recorder | |
| • | [=1+2] - runs an xl formula in vba | |
| • | Selection.NumberFormat = "m/d/yyyy" | |
| • | Formatcols - | |
| • | GetSignature | |
| • | Pastespecial pasteformats | |
| • | CreateHTMLTableForEmail (html, css,) - coverts spreadsheet visible data to HTML format | |
| • | FormatXyz - udf - to format data usually via recorded code, | |
| • | FixXYZFormat - the format of data needed to be fixed to a format that the code could process | |
| • | Activecell.FormulatR1C1 | |
| • | Convert formulas to values | |
| • | Columns("H:I").NumberFormat = "#,##0" | |
| • | format(lVersion,"000") | |
| • | CheckListForMOM - Automates a checklist that person used to verify data | |
| • | Selection.NumberFormat = (dup) | |
| • | Selection.NumberFormat = "mmm-yy" | |
| • | Selection.NumberFormat = "mmm-yy" (dup) | |
| • | Selection.Numberformat = "#,##0.0,,," | |
| • | Format dates | |
| • | Selection.Address - vb property - returns the $A$1 formatted address of the selected cell(s) | |
| • | Verify all data you get which helps when the format changes and it will new, changed, deleted | |
| • | Reference to Microsoft Forms 2.0 Object Library | |
| • | SendChecklist_email() - udf - sends a formatted email as a checklist to proper person to dbl check report | |
| • | Activecell.formulaR1C1 = | |
| • | Activecell.formulaR1C1 = "=If(RC[-32]=0,0,RC[-10]/RC[-32] | |
| • | s,Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ::-""??_);_(@_)" 'recorded (g) | |
| • | formatting routines - almost all are recorded and modified | |
| • | GTODList(sStype, aOffsets) - date Get Type of Date list format "3,6,12,15" a list of prev offsets | |
| • | VLookup as part of a formula with """ multiple quotes issue | |
| • | A01 FormatFromTemplate - udf - Report engine complex | |
| • | A01 FormatforPrinting - udf - report engine | |
| • | FormatFromTemplate - udf Report Engine | |
| • | FormatMultipleSheets udf | |
| • | XML File format | |
| • | Exponential Format | |
| • | Other forms of VBA (vb, vb.net, vbscript) | |
| • | Copy formula c7 - B7 and get weird values and need to do =if(c7="","",C7-B7)🔝 | |
| • | Formula error =A1-B1/2 | |
| • | Formula Error =C3-C2 and C2 is blank (if needed) | |
| • | Evaluate formula tool | |
| • | Debugging formula issues | |
| • | Normalized Forms - db | |
| • | Duplicates | |
| • | format(n,"#,##0") | |
| • | Show Formula Mode - Ctrl ` | |
| • | Formula vs. Value vs. Format | |
| • | Formula Bar | |
| • | Using fx to understand a formula | |
| • | If input file format changes | |
| • | Input file format is changed | |
| • | Covert Text date to date - cells(x,y).formula = cells(x,y).value (for all rows) | |
| • | FormatPrettyPrint |