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 |
| • | 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 |