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 |
• | a Order of learning | |
• | a Order of Learning List | |
• | a Excel/VBA for yourself vs. users of your sheets (18) | |
• | a filename can't use certain characters line "/" so change it if creating it from data | |
• | A01 CopyToDocumentumSweep - copies files to a network directory | |
• | A01 CreateWorkspace - vba | |
• | A01 Dim rsCOB As DAO.Recordset | |
• | A01 Dim WshShell As Object | |
• | A01 doc "text" ' udf documents the code | |
• | A01 DocumentsPath = WshShell.SpecialFolders(16) | |
• | A01 FormatforPrinting - udf - report engine | |
• | A01 FormatFromTemplate - udf - Report engine complex | |
• | A01 GTOD(e,offset, optional retDate) - udf Get Type of Date - c for Credit Studio, e for Everest | |
• | A01 IsRating - determines if a field is a rating range returns true/false | |
• | A01 vbLF | |
• | Abs(x) ' math absolute value | |
• | Abstraction - Chess means what? or any term table, chair | |
• | AC - udf sc - Activecell | |
• | Acronyms | |
• | Active | |
• | ActiveCell.Address | |
• | Activecell.Column | |
• | Activecell.formula | |
• | Activecell.formulaR1C1 = | |
• | Activecell.formulaR1C1 = "=If(RC[-32]=0,0,RC[-10]/RC[-32] | |
• | Activecell.formulaR1C1 = .... - code from macro recorder | |
• | Activecell.FormulatR1C1 | |
• | activecell.MergeArea | |
• | Activecell.mergecells | |
• | ActiveCell.Offset(1,0).Address | |
• | ActiveCell.Offset(1,0).select | |
• | Activecell.Row | |
• | ActiveSheet.Buttons.Add(top,left,width,height).select 'not sure of the params | |
• | ActiveSheet.ChartObjects(sFromAddr).Activate | |
• | Activesheet.ChartObjects(sToAddr).Delete | |
• | ActiveSheet.Copy After:=Workbooks(sMainWBK).Sheets(Sheets.count) | |
• | ActiveSheet.Index - gets the sheets number (not sure why you'd use this | |
• | ActiveSheet.name | |
• | Activesheet.Names(sName).Delete ' deletes a named range | |
• | ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 ' recorded | |
• | Activesheet.paste | |
• | Activesheet.PivotTables("PivotTable11").PivotFields("CtryOfDom").PivotItems ' recorded | |
• | ActiveSheet.PivotTables("PivotTable3").ChangePivotCache ... ' recorded | |
• | ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh ' recorded | |
• | ActiveSheet.PivotTables("PivotTable3").PivotFields("Region").ClearAllFields 'recorded | |
• | ActiveSheet.PivotTables("PivotTable3").PivotFields("Region").CurrentPage = sValue | |
• | ActiveSheet.PivotTables("pt1").ColumnGrand = True ' recorded | |
• | ActiveSheet.PivotTables("pt1").PivotFields("Acct_nbr").Autosort xldescending, sort ' recorded | |
• | ActiveSheet.PivotTables("pt1").PivotFields("coper_id").PivotFilters.Add Type:=xlTopCount, DataFiled:=... ' recorded | |
• | Activesheet.Shapes.Range(Array("Button 1")).Select | |
• | ActiveSheet.Unprotect | |
• | ActiveWindow.Activate | |
• | Activewindow.Caption | |
• | ActiveWindow.FreezePanes = True/False | |
• | ActiveWindow.SelectedSheets.Delete - recorded to delete multiple sheets (displayalerts=false) to turn off warning | |
• | ActiveWorkbook after opening an excel file | |
• | ActiveWorkbook.Close False | |
• | ActiveWorkbook.FullName | |
• | Activeworkbook.name | |
• | ActiveWorkbook.Names("dataset").RefersToR1C1 = "=cpt_input_data!R1C1:R40C13" | |
• | ActiveWorkbook.RefreshAll | |
• | ActiveWorkbook.Save | |
• | ActiveWorkbook.SaveAs sFile | |
• | ActiveWorkbook.SaveCopyAs sFile | |
• | ActiveWorkbook.Worksheets("....").Autofilter.sort.sortfileds.clear ' clears a filters sorting ' recorded | |
• | ActiveWorkbook.worksheets("sfile1").sort.sortfields.Add Key:=Range("N2"), SortOn:=xlSortOnValues, order:=xlAscending, DataOption=xlSortTextAsNumbers | |
• | Add Columns to a report | |
• | Add Columns to a Report Manually Maintained | |
• | Add Hyperlinks to a Report | |
• | addAITs | |
• | AddBorders | |
• | Added after time separate process to add more slides with complex rules | |
• | AddFieldToDB (sfield, sTable, stype) | |
• | AddFinalSlash - udf - files | |
• | AddLinks - convert Jira into links | |
• | AddRatingColumns | |
• | AddSemicolon - db - udf - adds a semicolon to the end of a string if one doesn't exist or to beginning as it's a comment | |
• | AdjustLabelPosition - udf - charts | |
• | Adjustment Logic | |
• | After opening an external spreadsheet verify that it's okay - coding | |
• | AHK to increase productivity (separate book) | |
• | AI - Checkers | |
• | AI BlackJack | |
• | ALED - A Little Each Day | |
• | Algebra vs Programming Assignment Statement | |
• | align_ok_key(lKeyCol1 as Long, range1, lkeyCol2 as long, range2) - udf - 🔝 Aligns data from 2 sources | |
• | Analogy between programming language and real language | |
• | API - Public Declare Function ShellExecute Lib "Shell32.dll" Alias "ShellExecuteA(ByVal hWnd As Long, ... | |
• | API - Public Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) | |
• | Applciatoin.UserName | |
• | AppLen - udf -wrapper - handles null value | |
• | Application.AskToUpdateLinks = false | |
• | Application.Autocorrect ' record | |
• | Application.Calculate | |
• | Application.CalculateFull ' recorded | |
• | Application.Calculation = xlCalculationAutomatic ' optimization | |
• | Application.Calculation = xlCalculationManual ' recorded | |
• | Application.Caption | |
• | Application.CutCopyMode = False - gets rid of crawling ants | |
• | Application.DisplayAlerts = False ' get rid of unneeded dialog box | |
• | Application.EnableEvents = False | |
• | Application.EnableEvents = True/False | |
• | Application.ErrorCheckingOptions.BackgroundChecking = False ' recorded optimize | |
• | Application.Evaluate("=vlookup(""" & ..... & """,'" & from .... | |
• | application.evaluate(sLookup) - runs a vlookup or match or other excel statemnt | |
• | Application.Height | |
• | Application.IgnoreRemoteRequests | |
• | Application.Left | |
• | Application.OnKey | |
• | Application.Ontime Dateadd("n",30, Now(),"Sub_to_run_name" ' i | |
• | Application.Run - can be used to run a passed function on parameters - code in pptools - Callback_testing | |
• | Application.ScreenUpdating = True/False ' used for optimization | |
• | application.statusbar = | |
• | Application.width | |
• | Application.WindowState = xlMaximized - recorded | |
• | Application.WindowState = xlNormal - recorded | |
• | Applicaton.WindowState = xlMaxmized ' recorded | |
• | Appplication.Top | |
• | AR - sc for Activecell.row | |
• | Archive | |
• | AreTheyTheSame - internet function udf to check if 2 files are the same | |
• | Array -start with "a", array function | |
• | Array(string, string, ....) - Converts a list of strings to an array | |
• | Arrays vs. Collections | |
• | As Boolean (duplicate) | |
• | As Boolean ... True/False | |
• | As Byte | |
• | As DAO.Recordset | |
• | As Excel.Range | |
• | as Integer | |
• | As Long | |
• | As Object | |
• | as Outlook.Application | |
• | as Range | |
• | as Single | |
• | as String | |
• | as Variant | |
• | As Word.Application | |
• | As Word.Document | |
• | As Worksheet | |
• | Asc( ) - VBA string func converts s to a number | |
• | Ask user a question and proceed from their answer | |
• | Ask user via DispYN - (ex. run full version or "quick" one) | |
• | ASP | |
• | Assign a value to a cell - Range("xxx") = "a value" | |
• | Assignment stmt | |
• | Attach a file to an email | |
• | auto_open - udf | |
• | autocomplete | |
• | AutoFilterMode | |
• | Autofit | |
• | AutoHotKeys | |
• | Automate Manual Tasks |