• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel VBA

automating and emailing pivot table reports

Automating and Emailing Pivot Table Reports

March 11, 2020 by Philip Treacy

Here's the scenario: I want to send different pages of my pivot table report to different email recipients. I can do this by hand but it takes forever to change the filter, copy/paste, or export the report and then create and send the email, even just for a few people. And when I do this …

Read moreAutomating and Emailing Pivot Table Reports
Checking values in range objects with vba

Checking Values in Range Objects With VBA

October 30, 2019 by Philip Treacy

One thing I often found frustrating with VBA is the lack of any easy way to see the values in a range object. I often use Debug.Print when debugging my VBA and I'd love to just be able to Debug.Print a range like you can with other variables. But because a range is an object, …

Read moreChecking Values in Range Objects With VBA
Static variables in VBA

Static Variables in VBA

April 4, 2019 by Philip Treacy

Normally variables cease to exist once your Sub or Function has finished executing. Static variables allow you to preserve a value after your code has finished. Let's say you want to keep track of the number of times something happens, like how many times someone clicks on this button they are not supposed to.

Read moreStatic Variables in VBA
save chart as image

Save Chart as Image

November 30, 2018 by Philip Treacy

You might want to save your charts as images that can then be used in other applications, like email or displayed on a website. Selecting a single image then copying/pasting or saving it, isn't too much bother. But if you want to do that for several images it quickly becomes tiresome. I've written some VBA, …

Read moreSave Chart as Image
Clearing Downstream Dependent Data Validation Lists

Clear Downstream Dependent Data Validation Lists

August 25, 2016 by Philip Treacy

Following on from Mynda's post last week on Dependent Data Validation, I've written a little VBA that enhances the functionality. What this code does is to clear any cells dependent on the value of another data validation list. I'll call these downstream cells. So if I change the Country, I'm going to clear the values …

Read moreClear Downstream Dependent Data Validation Lists
Excel Status Bar

Excel Status Bar

June 15, 2016 by Philip Treacy

In my previous blog post I created a progress bar using a userform. We can use this progress bar to communicate to our Excel user that our VBA code is still running. In this post I’m going to look at using the Status Bar to do the same thing, and create something like this. Status …

Read moreExcel Status Bar
Progress Bar for Excel VBA

Excel Progress Bar for VBA

June 9, 2016 by Philip Treacy

If your code runs for any noticeable amount of time, you might find that using some sort of visual feedback is useful for your users. Letting them know just how long something will take to complete, and just as importantly, letting them know that Excel hasn't hung, reassures them that the code is working and …

Read moreExcel Progress Bar for VBA
error handling in vba

Error Handling in VBA

December 4, 2015 by Philip Treacy

If VBA can’t execute a statement (command) then a run-time error occurs. By default Excel deals with these, so when a run-time error occurs, you'll see a default error message like this: But you can change this and instruct Excel to allow your code to deal with run-time errors. NOTE : I’m going to use …

Read moreError Handling in VBA
Finding File Metadata Using FileSystemObject

Finding File Meta Data Using FileSystemObject

November 6, 2015 by Philip Treacy

In a previous post I looked at using the FileSystemObject to search through folders on your computer's disk and create a hyperlinked list of files. Clicking on the hyperlink would open the file. FileSystemObject (FSO) can also be used to retrieve meta data from a file, like the creation date, last modified date or file …

Read moreFinding File Meta Data Using FileSystemObject
Automatically Add Items to Data Validation List

Automatically Add Items to Data Validation List

September 25, 2015 by Philip Treacy

If you are using data validation (and you should) to help you with your data entry, then you might find that the list you are using doesn't have all the values you want. For example, if you were using a list to assign a priority to some work, your list may consist of 'Not Started', …

Read moreAutomatically Add Items to Data Validation List
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Next

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.