By using you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σ


Standard VBA/Excel (59 of 1182)

(Clear Filter = *Form*)

Date formatting yyyy-mmm-dd
cl - udf - converts a # to the AA format
(xxx) to convert to proper format - cok ??
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 - Format the excel while recording
GetSignature - gets a number based on the number of formulas + number of rows * cols
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
Convert formulas to values
Columns("H:I").NumberFormat = "#,##0"
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,, 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
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)