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 |
• | s,Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ::-""??_);_(@_)" 'recorded (g) | |
• | SaveAllAsPDFFile - Internet - https://howto-outlook.com/howto/saveaspdf.htm - Robert Sparnaaij | |
• | SaveCopyAs | |
• | SaveStringToFile - udf 🔝 | |
• | SaveStringtoFile string, "c:\xyz.txt" - saves a string to a file | |
• | sCol = cl((c)) | |
• | Scope of variables | |
• | Screen Flashing Problem | |
• | Scripting.FileSystemObject" | |
• | Searching for Excel/VBA Answers | |
• | SECDataAvailable - udf - db - checks for a condition (cob date from db > month-end data) and send email, generates a file | |
• | Second(now()) | |
• | Select a cell - Range(...).select | |
• | Select a column - Columns(i).select | |
• | Select Case - vba stmt | |
• | Select Case | |
• | Selection Pane | |
• | Selection. (formula, copy) | |
• | Selection.Address - vb property - returns the $A$1 formatted address of the selected cell(s) | |
• | Selection.Autofill destination:=Range("H2:I" & r) | |
• | Selection.autofilter = turns off filter | |
• | Selection.Characters.Text = "Add TOC" ' after selecting a button, you can change the text | |
• | Selection.Copy - copies the active selection to the clipboard | |
• | Selection.copy | |
• | Selection.CurrentRegion.Select | |
• | Selection.cut - Clipboard | |
• | Selection.Delete Shift:=xlUp ' recorded | |
• | Selection.End(xlUp).select ' recorded | |
• | Selection.EntireColumn.Hidden = True ' recorded | |
• | Selection.Font.Underline = xlUnderlinestyleSingle | |
• | Selection.Insert Shift:=xlToRight - recorded | |
• | Selection.Left or Top, Height, width, name after chartobject is activated | |
• | Selection.Merge | |
• | Selection.Numberformat = "#,##0.0,,," | |
• | Selection.NumberFormat = "m/d/yyyy" | |
• | Selection.NumberFormat = "mmm-yy" (dup) | |
• | Selection.NumberFormat = "mmm-yy" | |
• | Selection.NumberFormat = (dup) | |
• | Selection.OnAction = "TOC1.AddTocSheet" ' Select the shape first via ActiveSheet.Shapes.Range(Array("Button 1")).Select | |
• | Selection.PasteSpecial ... ' recorded | |
• | selection.PasteSpecial Paste:=xlPasteColumnWidths, ..' recorded | |
• | Selection.Pastespecial Paste:=xlPasteValues... 'recorded | |
• | Selection.Replace what:="#N/A", Replacement:="0", LookAt... 'Recorded | |
• | Selection.Rows.Count | |
• | Selection.WrapText = False ' recorded | |
• | SelectPartialSheetName - I wouldn't know the whole name of a sheet but knew part of it's name | |
• | Seletction.Style = "Percent" ' recorded | |
• | SendChecklist_email() - udf - sends a formatted email as a checklist to proper person to dbl check report | |
• | SendEmailFromList - Goes thru a spreadsheet and Sends emails | |
• | Sendkeys "^A",True | |
• | sendmail_cdo udf | |
• | sendmail_cdo | |
• | SendMailto( ) udf | |
• | SeqIO.bas | |
• | set fso = CreateObject("scripting.filesystemobject") | |
• | Set gADO = GetConnection(GetDatasource()) | |
• | Set gADO = GetConnection(GetDatasource()) | |
• | Set IE = New InternetExplorer | |
• | set iMsg = CreateObject("CDO.Message") | |
• | set objSelection = objOL.ActiveExplorer.Selection (not sure what this is) | |
• | Set PPApp = GetObject(, "Powerpoint.Application") | |
• | Set PPT = CreateObject("Powerpoint.Application") | |
• | Set ppttemplate = PPT.Presentations.Open(sFile, ReadOnly = msoTrue | |
• | Set rs = nothing | |
• | set wb = ActiveWorkbook | |
• | set wrdApp = CreateObject("Word.Application") | |
• | Set x = CreateObject("MSXML2.XMLHTTP") | |
• | SetAttr | |
• | SetAttr sFilename, vbReadOnly | |
• | SetAutoFitMergedCell udf Report Engine | |
• | Setting a Hyperlink on a cell in a ppt table | |
• | Setting Sheet | |
• | Shapes, Smartart, Screenshots | |
• | SharePoint | |
• | sheet names | |
• | Sheet names have size and character limitations | |
• | SheetExists - udf | |
• | Sheets aka WorkSheets | |
• | Sheets Collection | |
• | sheets vs. worksheets collection? | |
• | Sheets("name").select - selects a sheet | |
• | Sheets(2).visible = True | |
• | Sheets(Array("sheet1","sheet2").copy | |
• | Sheets.count | |
• | ShellAndWait API | |
• | Show directory via File Explorer - RunProgram "C:\directory_name" | |
• | Show Formula Mode - Ctrl ` | |
• | ShowSheet - udf - wraps the code to prevent errors | |
• | Sleep - API | |
• | Slicer | |
• | Small to big - coding technique | |
• | Small to big, one piece at a time | |
• | Space$(512) | |
• | Sparklines | |
• | Special Characters | |
• | Split(string,"value") - converts string into an array | |
• | SpreadSheetRoutines.bas | |
• | SQL - Check return from query | |
• | SQL Create | |
• | SQL delete | |
• | SQL drop | |
• | SQL insert rows from data | |
• | SQL insert | |
• | SQL truncate | |
• | SQL update | |
• | SQL | |
• | SQLStuff.bas | |
• | SSRS - SQL Server Reporting Services | |
• | Stack - Used in Call Stack | |
• | Standard error handling | |
• | Static variable | |
• | Status while running a process so user doesn't think it hung up🔝 | |
• | Status | |
• | StatusBar | |
• | Stop | |
• | Stop: resume next: Resume - Debugging and why? | |
• | Stopping Running Code - Ctrl Break | |
• | Strings | |
• | stringtobytearray - internet | |
• | Student Knowledge | |
• | Sub - End Sub | |
• | subroutine parameters | |
• | Subscript out of range | |
• | Subtotal function - excel | |
• | Summary Statistics | |
• | Syntax Checker | |
• | Syntax errors | |
• | Syntax |