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

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (128 of 1182)

(Clear Filter = S*)

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
Top