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 (60 of 1182)

(Clear Filter = P*)

Pacing - Productivity Issue
Pacing Tool to increase productivity
Pain Point
Paint
Parts of a URL
Password protecting your Macros
Paste
Pastespecial pasteformats
PasteValues
Pause processing and verify data
Pause Running Macro - Esc or Ctrl Break
PDFPrint
Percentages
Personal.xlsb
PivotFields("field_name").Orientation = xlHidden
PivotFields("field_name").Orientation = xlRowField
PivotFields("field_name").Position = 6
PivotFields("field_name").Subtotals = Array(False, False, ...)
Plan to get book/training done
Popup - udf
Popup - ui - udf - Display a msgbox that disappears
Positive (+) and Negative (-) Numbers
Postitive "If" test vs. complex not
Power BI
Power Pivot
Powershell
PPT Object Model
PPT test code to update embedded spreadsheet in ppt
PPT.ActivePrenstation.Slides(2).select
PPT.ActivePresentation.Close
PPT.ActivePresentation.Save
PPT.ActivePresentation.SaveAs sFile
PPT.ActivePresentation.Slides(n) - the nth slide oblect name to use in a with stmt
PPT.ActivePresntation.Slides.count - gets the last slide
PPT.ActiveWindow.Selection.SlideRange.SlideNumber - get the active slides #
PPT.Presentations.Open sFile, ReadOnly:=msoTrue
PPT.Visible = True
pptshp.HasTable
pptshp.Table.Cell(i, 1).Shape.TextFrame.TextRange.Text - gets the text from a pptshp cell
pptshp.table.Columns.Count
pptshp.Table.Rows.count
Precedence
Preview emails before sending
PreviewEmail
Print #x,string
Private scope
Problems
Processing Multiple Errors
ProcessSQL - udf - very important 🔝
ProcessSQL(sSQL, sSheet, optional sProcess
progressWorkflowAction
Project Explorer
Project: SQL UI
Properties
Protect/Unprotect a sheet
Protecting a Sheet
Ptrsafe
public gADO As ADODB.Connection
Public gsFilters() As Filter_fields 'Filter fields is a udt
Public or Global variables
Top
   
Home | Excel Syntax Checker | About | Videos | Feedback | @alecberg | websites | FAQ | Memes | Thanks | Copyright © 2021 All Rights Reserved. Edit