Excel VBA – ActiveX Controls, Form Controls & AutoShapes on a Worksheet ———————————————————————————————– Contents: Forms in Excel ActiveX controls, Form controls & AutoShapes in an Excel Worksheet Shape object & OLEObject object ActiveX Controls in VBA Add an ActiveX Control, a Form Control or an AutoShape, in Worksheet Illustrating Form Controls, ActiveX Controls & AutoShapes:...
Tag: Excel VBA tutorial
ChartFormat object – line, fill & effect formatting for chart elements: FillFormat object, LineFormat object, ShadowFormat object, GlowFormat object, SoftEdgeFormat object, ThreeDFormat object
ChartFormat object – line, fill & effect formatting for chart elements: FillFormat object, LineFormat object, ShadowFormat object, GlowFormat object, SoftEdgeFormat object, ThreeDFormat object Contents: The ChartFormat object The FillFormat obj Setting ForeColor & BackColor for the Fill Setting a Solid Fill Setting Gradient Type for the Fill Gradient Stops – the End Points of Color...
Child Objects common for many chart elements: Border Object, ChartFillFormat Object, Interior Object, Font Object
Child Objects commonly used with Chart Elements: Border Object, ChartFillFormat Object, Interior Object, Font Object Contents: Border Object ChartFillFormat Object Interior Object Font Object You can use the Border object, ChartFillFormat Object, Interior Object & Font Object with several Chart Elements to customize the border, fill, interior and font settings. Each object has multiple properties...
Chart Elements in Excel VBA (Part 2) – Chart Series, Data Labels, Chart Legend
Chart Elements in Excel VBA (Part 2) – Chart Title, Chart Area, Plot Area, Chart Axes, Chart Series, Data Labels, Chart Legend Contents: Chart Series DataLabels Object / DataLabel Object Chart Legend This chapter discusses some important chart elements contained on a chart, which include: chart area (ChartArea object); chart title (ChartTitle object); plot area...
Chart Elements in Excel VBA (Part 1) – Chart Title, Chart Area, Plot Area, Chart Axes
Chart Elements in Excel VBA (Part 1) – Chart Title, Chart Area, Plot Area, Chart Axes, Chart Series, Data Labels, Chart Legend Contents: Chart Title Chart Area Plot Area Chart Axis This chapter discusses some important chart elements contained on a chart, which include: chart area (ChartArea object); chart title (ChartTitle object); plot area (PlotArea...
Charts in Excel VBA – Add a Chart, the Chart object & the ChartObject object
Charts in Excel VBA – Add a Chart, the Chart object & the ChartObject object Contents: Worksheet & Chart Sheet in Excel Add a Chart ChartObject object Chart object Excel is a great tool to create charts quickly & easily, to display worksheet data in a meaningful manner for users. This section illustrates creating &...
Create Charts in Excel VBA: Embedded Charts – Line with Markers; Clustered Stacked Column Chart; Clustered Stacked Bar Chart displaying Variance; Pie chart; XY Scatter chart & Bubble chart
Create Charts in Excel VBA: Embedded Charts – Line with Markers; Clustered Stacked Column Chart; Clustered Stacked Bar Chart displaying Variance; Pie chart; XY Scatter chart & Bubble chart Contents: Create an Embedded Chart – Line with Markers Creating a Clustered Stacked Column Chart Create a Clustered Stacked Bar Chart displaying Variance between Series Pie...
Excel VBA Debugging Tools in Visual Basic Editor – Breakpoints & Break Mode, Stepping Through Code, Debugging Views
Excel VBA Debugging Tools in Visual Basic Editor – Breakpoints & Break Mode, Stepping Through Code, Debugging Views ————————————————————— Contents: Debug Code by using a Message Box Use Breakpoints to Debug Code Using Break Mode to Debug Code Stepping Through Code Debugging Views Immediate Window Locals Window Watch Window Call Stack ————————————————————— Debugging is a...
Excel VBA Errors & Error Handling, On Error & Resume Satements, Exit Statement, Err Object
Excel VBA Errors & Error Handling, On Error & Resume Satements, Exit Statement, Err Object ————————————————————————————————- Contents: VBA Erros & Error Handling Error Handling Setting, in VBE Error Handler On Error Statements Using an Exit Statement Error Handling in Nested Procedures & The Resume Statement Get Information from the Error Object Raise Method...
Excel VBA Date & Time Functions; Year, Month, Week & Day Functions
Excel VBA Date & Time Functions; Year, Month, Week & Day Functions —————————————————– Contents: VBA DateSerial Function VBA DateValue Function VBA TimeSerial Function VBA TimeValue Function VBA IsDate Function VBA CDate Function VBA DateAdd Function VBA DateDiff Function VBA DatePart Function VBA Date Function VBA Now Function VBA MonthName Function VBA Day Function VBA Month...
Excel VBA – Message and Input Boxes in Excel, MsgBox Function, InputBox Function, InputBox Method
Excel VBA – Message and Input Boxes in Excel, MsgBox Function, InputBox Function, InputBox Method —————————————————————————————————————————— Contents: Using Message Box in vba code MsgBox Function Example: Message Box Buttons options Example: Set Default Button for Message Box Example: Format MsgBox Example: Using MsgBox return values with Select_Case statemnts Example: Using MsgBox return values with If_Then...
Excel VBA String Functions: SPLIT, JOIN, CONCATENATE
Excel VBA String Functions: SPLIT, JOIN, CONCATENATE Excel VBA Functions to Split a String into Substrings, and Join an Array of Substrings to form a String, with Examples. Also refer Related Link: Excel VBA String Functions: LEFT, RIGHT, MID, LEN, REPLACE, INSTR, INSTRREV —————————————————————– Contents: Split Function (VBA) Join Function (VBA) Concatenate with & (Worksheet...
Excel VBA String Functions: LEFT, RIGHT, MID, LEN, REPLACE, INSTR, INSTRREV
Excel VBA String Functions: Excel VBA String Functions for Finding and Replacing Text, with Examples: LEFT, RIGHT, MID, LEN, REPLACE, InStr & InStrRev Functions ——————————————————- Contents: LEFT Function (Worksheet / VBA) RIGHT Function (Worksheet / VBA) MID Function (Worksheet / VBA) LEN Function (Worksheet / VBA) REPLACE Function (Worksheet) REPLACE Function (VBA)...
Excel VBA – Empty, ZLS, Null, Nothing, Missing
Excel VBA – Empty, ZLS, Null, Nothing, Missing ———————————– Contents: Empty VarType Function Null Nothing Missing ———————————– In excel vba we often refer to an Empty variable, ZLS (zero-length string) or null string or vbNullString, Null value, Missing Argument, or using the Nothing keyword with an object variable. It is important to differentiate and understand...
Excel VBA Worksheets – Refer, Activate or Select, Add & Name, Copy or Move, Hide or Display, Delete, Page Layout & View, Calculate
Excel VBA Worksheets – Refer, Activate or Select, Add & Name, Copy or Move, Hide or Display, Delete, Page Layout & View, Calculate Related Links: Working with Objects in Excel VBA Excel VBA Application Object, the Default Object in Excel Excel VBA Workbook Object, working with Workbooks in Excel Excel VBA Range Object, Referencing Cells...
Excel VBA Refer to Ranges – Union & Intersect; Resize; Areas, CurrentRegion, UsedRange & End Properties; SpecialCells
Excel VBA Refer to Ranges – Union & Intersect; Resize; Areas, CurrentRegion, UsedRange & End Properties; SpecialCells An important aspect in vba coding is referencing and using Ranges within a Worksheet. You can refer to or access a worksheet range using properties and methods of the Range object. A Range Object refers to a cell...
Excel VBA Referencing Ranges – Range, Cells, Item, Rows & Columns Properties; Offset; ActiveCell; Selection; Insert
Excel VBA Referencing Ranges – Range, Cells, Item, Rows & Columns Properties; Offset; ActiveCell; Selection; Insert You can refer to or access a worksheet range using properties and methods of the Range object. A Range Object refers to a cell or a range of cells. It can be a row, a column or a selection...
Excel VBA Workbooks – Reference, Open, Add, Name, Save, Activate, Copy & Close Workbooks; SendMail Method
Excel VBA Workbooks – Reference, Open, Add, Name, Save, Activate, Copy & Close Workbooks; SendMail Method Related Links: Working with Objects in Excel VBA Excel VBA Application Object, the Default Object in Excel Microsoft Excel VBA – Worksheets Excel VBA Range Object, Referencing Cells and Ranges Excel VBA Custom Classes and Objects ————————————————————————————– Contents: The...
Excel VBA Dates & Time, Format Function, User Defined Date, Number & String Formats
Excel VBA Dates & Time, Format Function, User Defined Date, Number & String Formats ————————————————————————————————————— Contents: Excel VBA Dates & Time Format Function in VBA Named Date/Time Formats Named Numeric Formats Characters used to create User-Defined Number Formats with the VBA Format Function Characters used to create User-Defined Date & Time Formats with the VBA...
Excel VBA Online Tutorial – learn Excel VBA programming & access examples, illustrations, live codes and downloadable files
Excel and VBA Solutions Excel VBA Programming – Enhance your Excel skills Visual Basic for Applications (VBA) is a programming language used to work with Microsoft Excel, and also with other Microsoft Office applications like Word, Access, PowerPoint & Outlook, and with many third-party applications. VBA for Excel: VBA programming is used to get enhanced...
Excel VBA Application Object – the Default Object in Excel
Excel VBA Application Object, Properties & Methods Related Links: Working with Objects in Excel VBA Excel VBA Workbook Object, working with Workbooks in Excel Microsoft Excel VBA – Worksheets Excel VBA Range Object, Referencing Cells and Ranges Excel VBA Custom Classes and Objects ———————————————————————————————————– Contents: The Application Object Instances where using the Application...
Starting with VBA in Excel, Writing VBA Code for Macros or Procedures
Starting with Excel VBA, Writing VBA Code ———————————————————– Contents: Excel VBA Objects, Properties & Methods Event Procedures in VBA Visual Basic Editor (VBE) Modules in Excel VBE VBA Procedures Creating a sub-procedure Run or Execute a Procedure Line Continuation within VBA code Auto Syntax Check Comment Text within VBA code Indenting your VBA code Using...
Excel VBA Objects; Excel Object Model; Access a Workbook, Worksheet or Range Object; Set Object Properties & Call its Methods
Excel VBA Objects; Excel Object Model; Access a Workbook, Worksheet or Range Object; Set Object Properties & Call its Methods ———————————————————————————– Contents: VBA Objects The Excel Object Model Active Object Access an Object / Access a Single Object from its Collection Properties and Methods of Objects Working with Objects in Excel VBA ———————————————————————————– An object...
Microsoft Access DAO Object Model: Import or Export Data from Access to Excel
Microsoft Access DAO Object Model: Import or Export Data from Access to Excel Microsoft Access: Data Access Objects Library (DAO), Connect with Access Databases from Excel using VBA. Part 3 of 3 Microsoft Access: Data Access Objects Library (DAO), Connect with Access Databases from Excel using VBA. 1. Connecting to Microsoft Access Database from Excel...
Microsoft Access DAO Object Model: Create an Index, Create Relationship between Fields, Create and Exceute a Query
Microsoft Access DAO Object Model: Create an Index, Create Relationship between Fields, Create and Exceute a Query Microsoft Access: Data Access Objects Library (DAO), Connect with Access Databases from Excel using VBA. Part 2 of 3 Microsoft Access: Data Access Objects Library (DAO), Connect with Access Databases from Excel using VBA: 1. Connecting to Microsoft...
Connecting to Microsoft Access Database from Excel VBA, using DAO Object Model
Connecting to Microsoft Access Database from Excel VBA, using DAO Object Model Microsoft Access: Data Access Objects Library (DAO), Connect with Access Databases from Excel using VBA. Part 1 of 3 Microsoft Access: Data Access Objects Library (DAO), Connect with Access Databases from Excel using VBA 1. Connecting to Microsoft Access Database from Excel VBA,...
Import Contacts from Excel to Outlook – automate in vba
Import Contacts from Excel to Outlook – automate in vba —————————————————————————————————————– Contents: Automating Microsoft Outlook from Excel Export data from an Excel Worksheet to the default Contacts folder (new contact items added with Application.CreateItem Method), using Early Binding Export data from an Excel Worksheet to the specified Contacts folder (new contact items added...
Export contacts from Outlook to Excel – automate in vba
Export contacts from Outlook to Excel – automate in vba ————————————————————————————————————————– Contents: Automating Microsoft Outlook from Excel Export contacts from a specific Contact Items Folder to an Excel Worksheet, using Early Binding Export contacts from the default Contact Items Folder to an Excel Worksheet, using Late Binding ————————————————————————————————————————– Data from Outlook...