Skip to content
ExcelAnyTime
  • Home
  • Ebook of Excel Formulas
  • Excel VBA Online Tutorial
  • Excel Models
  • Services
  • Contact
  • Sign Up/Login
    • Sign Up
    • Login
    • Forgot Password
Type and press enter to search

Login

Login

Home / Login

Login

Lost your password?

SignUp
Forgot Password

VBA Tutorial Login

Hi ,Logout

Excel & VBA

  • Excel VBA Basics
    • Excel VBA – Introduction
    • VBE – the VBA Code Editor
    • Record & Run Macros
    • Starting with VBA, Writing Code
    • Message Box & Input Box
  • Excel VBA Objects
    • Working with Objects
  • Working with Variables
    • Declare Variables in VBA
  • Conditional Statements
    • If…Then…Else Statements
    • Select…Case Statements
  • Excel VBA Loops
    • Excel VBA For & Do Loops
  • Excel Application Object
    • Application Object, Properties & Methods
    • Application.OnTime VBA, Schedule Macros
  • Workbooks & Worksheets
    • Workbook Object, Properties & Methods
    • Worksheet object, Properties & Methods
    • Run Macros on Protected Worksheet
  • Excel VBA Cells & Ranges
    • Referencing Cells & Ranges – 1
    • Referencing Cells & Ranges – 2
    • Find Method in Excel VBA
    • VBA – Last Used Row & Column
  • Text, String & Date Functions
    • VBA String Functions – Left, Right, Mid, Len, Replace, InStr & InStrRev
    • VBA String Functions – Split, Join, Concatenate
    • Functions – CODE & CHAR / Asc & Chr
    • ASCII & ANSI Code, Extended ASCII characters
    • Column No. to Letter, Column Letter to No.
    • VBA Convert to UpperCase / LowerCase
    • Excel VBA Dates & Time, Format Function
    • Excel VBA Date and Time Functions
    • Custom Number Formats, Date Formats
  • Excel VBA Procedures
    • Subs & Functions, Placement in Modules
    • Pass Arguments to Procedures, ParamArray
    • VBA – Empty, ZLS, Null, Nothing, Missing
  • Excel VBA Arrays
    • Excel VBA Arrays
  • Error Handling & Debugging
    • Error Handling in VBA
    • Debugging Tools in VBE
  • Excel VBA Events
    • Excel VBA Built-in Events
    • Worksheet Change Event
    • Worksheet Selection Change Event
  • Custom Classes & Objects
    • Custom Classes & Objects, Custom Events
  • ActiveX & Form Controls, AutoShapes
    • ActiveX & Form Controls, AutoShapes
  • UserForms in Excel VBA
    • UserForm Basics, Add Controls
    • UserForm and Controls – Properties
    • Label, TextBox & CommandButton
    • ComboBox & ListBox
    • CheckBox, OptionButton, ToggleButton
    • Frame, MultiPage & TabStrip
    • ScrollBar & SpinButton
    • Image & RefEdit
  • Charts in Excel VBA
    • Add a Chart, Chart & ChartObject objects
    • Chart Elements: Chart Title, Chart & Plot Area, Axes
    • Chart Elements: Chart Series, Data Labels, Legend
    • Border / ChartFillFormat / Interior / Font Objects
    • ChartFormat object, Formatting, 3D Charts
    • Create Line, Column, Pie, Scatter, Bubble charts
  • Excel Pivot Tables with VBA
    • Create Pivot Table using VBA
    • Referencing Pivot Table Range
    • Reference Pivot Fields & Items
    • Pivot Table Move & Copy
    • Pivot Table Layout & Design
    • Pivot Table Properties & Settings
    • Refresh Pivot Table & Cache
    • Group Items, Data & Date Values
    • Sort Fields, Values & Dates, Custom Lists
    • Filter Data, Items, Values & Dates
    • Summary Functions, Custom Calculations
    • Insert Calculated Fields, Create Formulas
    • Create Pivot Table Charts
  • Automation with VBA
    • Automate Microsoft Word from Excel
    • Automate Microsoft Outlook from Excel
    • Export contacts from Outlook to Excel
    • Import Contacts from Excel to Outlook
    • Automate Outlook, Send Email from Excel
    • Automate PowerPoint from Excel
  • Connect with Databases (ADO)
    • Microsoft Access: ADO Library
    • Execute SQL statements – ADO
    • Import / Export Data, Access to Excel
    • Connect to Access from Excel – ADOX
  • Connect with Databases (DAO)
    • Connect to Access from Excel – DAO
    • Create Index & Relationships, Exceute Query
    • Import / Export Data from Access to Excel

Excel & VBA

  • Excel Tips
  • Excel Functions
  • Excel VBA
  • Excel Pivot Tables

Ebook of Excel Formulas

  • Ebook
    • Ebook of Excel Formulas
  • Extract Unique Values
    • Extract Unique Values in a Column
    • Extract Unique Items in a Column, Skip Values
    • Extract Values which appear only once in a column
    • Extract Unique List of 1st 5 Characters from each column cell
    • Extract Unique Values appearing in one column and Not in other
    • Sort & Extract Unique values, appearing in one column & Not in other
  • Extract Duplicate Values
    • Extract Duplicates in 2 Columns
  • Sort & Rank Values
    • Rank Values in Custom Order
    • Rank & Sort Column Values, Ignoring Error Values
    • Extract a Sorted List of Unique values in a column
    • Split Values into Multiple Groups per their rank
  • Count Uniques & Duplicates
    • Count Unique Values in Excel
    • Count Unique Values with Conditions in Excel
    • Count Unique Values appearing in only one or in both columns
    • Count Once for occurrence of a value in all columns of same row
    • Count Once for occurrence in one or multiple columns
    • Count Unique Values matching Array Criteria in Excel
    • Count Unique Names, where each corresponds to Multiple Values
    • Count Unique values, with Multiple AND / OR Criteria
    • Count Rows which contain each of the multiple specified Values
    • Count Maximum number of Consecutive occurrences of same Value
    • Count Groups of consecutive positive values in Excel
    • Count number of Continuous non-blank cells which appear Last
    • Count Rows with occurrence of atleast one specific value
  • Sum Unique Values
    • SUM Values for Items which appear only Once
  • Count & Countif
    • Countif with Multiple AND / OR Criteria
    • Countif Array Criteria, Multiple Columns, AND / OR conditions
    • Count Occurrences of a Value as a whole or in part, in Column Range
    • Count column cells containing Specific Letter(s) within other text
    • Count Occurrences of Multiple Unique Values in a column
  • Count Non-Contiguous Ranges
    • COUNTIF Non-Contiguous Cells, with Wildcards, & Date Range
    • Count Cells in Non-Contiguous Ranges, where a value occurs in whole or in part
    • Count occurrences and relate to respective values, return SUM
  • Sumif & Countif Hidden Cells & Rows
    • Sumif to Exclude Cells Hidden with the Hide Rows command
    • Sumif to Exclude Cells Hidden by a Filter
  • Sum & Sumif
    • Sumif with Multiple AND / OR Criteria
    • SUMIF with Date range, Multiple months & year
    • SUM Max values of Each Row, in a Multiple Column Range
    • SUM Cell values containing any of the Multiple Values in Full or in Part
    • Sum Largest 5 out of Last 12 column values in Excel
  • Sum NonContiguous Ranges
    • SUMIF Non-Contiguous Cells, with Wildcards, & Date Range
    • SUM each block of consecutive cells in non-Contiguous Ranges
    • Assign separate values for items in Non-Contiguous cells & return SUM
    • SUM Largest 4 values in non-contiguous cells of a row
    • SUM Smallest 3 values in non-contiguous cells with Uneven Intervals
    • Sum Diagonal Cells of a Range in Excel
  • Average and Averageif
    • Average Last 10 column values, exclude Highest / Lowest
    • Average First 10 column values in a Column, Ignore Error Values
    • Average of Last 20 Positive values only in a Column
    • Average Largest 5 column values, per Matching Id
    • Average of Consecutive Negative Numbers
  • Average NonContiguous Ranges
    • Average of Non-Contiguous cells which are evenly distributed
    • Average of Non-Contiguous cells which are unevenly distributed
  • Dates, Days & Months
    • Calculate End Date / Time from Start Date / Time per given Work Hours in Excel
  • String & Text Formulas
    • Reverse First Name & Last Name
    • Split Names – Extract First, Middle & Last Names in Separate Cells
    • Position of First Text Character in a String
    • Position of First Number in a String
    • Position of Last Numeric in a String
    • Extract the Number Preceding Specific Text in a String
    • Extract Text after Last Blank Space in a String
    • Extract Text After Last Occurrence of a Number in a String
  • About Us
  • Testimonials
  • Website Use Policy
© 2024 Excelanytime.com All Right Reserved.
Scroll to top