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: methods
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 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 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...
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...
Excel VBA Custom Classes & Objects, Class Modules, Custom Events
Excel VBA Custom Classes & Objects, Class Modules, Custom Events ————————————————————— Contents: Custom Classes and Objects Custom Class Events ————————————————————— In vba you can create your own custom objects by defining classes & inserting class modules. You can also create your own custom class events, in addition to Excel’s own inbuilt event procedures. In this...