• 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
    • 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
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel VBA

How To Use VBA Code From The Internet

How To Use VBA Code From The Internet

November 27, 2013 by Philip Treacy

So you’ve found some VBA code on the ‘net that will save you hours and hours of work, but how do you get it into Excel and use it? Often I’ve seen snippets of code posted on sites that won’t work unless you know where to put them in Excel, and how to actually get …

Read moreHow To Use VBA Code From The Internet
How To Enable the Developer Tab in Excel

How To Enable the Developer Tab in Excel

November 27, 2013 by Philip Treacy

The Developer tab in Excel gives you access to features and tools that help you to write and run macros.  It’s not enabled by default so this is what you do to get access to it. Excel 2007 Click the Microsoft Office button (the round button at top left) Click on Excel Options Click Popular …

Read moreHow To Enable the Developer Tab in Excel
VBA to Create PDF from Excel Worksheet Then Email It With Outlook

VBA to Create PDF from Excel Worksheet Then Email It With Outlook

October 14, 2013 by Philip Treacy

Real World Scenario One of my customers (thanks Tony) creates invoices in Excel for his clients and at the end of each month he wants to email these invoices to each of those clients. Each invoice is on a separate worksheet. If he has a lot of sheets doing this one by one will quickly …

Read moreVBA to Create PDF from Excel Worksheet Then Email It With Outlook
Merge Excel Worksheets with VBA

Merge Excel Worksheets with VBA

October 1, 2013 by Philip Treacy

The Scenario Let’s say that you have a lot of sheets in your workbook and you want to merge all the data onto a single worksheet. If you have your data laid out in the same way on each sheet then this piece of VBA will do the trick for you.  Maybe you have sales …

Read moreMerge Excel Worksheets with VBA
Finding Missing Numbers in a Range Using VBA

Finding Missing Numbers in a Range Using VBA

September 11, 2013 by Philip Treacy

The Problem You have a sequence of numbers, and you want to find the numbers that are missing from that sequence. Let's use some VBA. Watch This Video - It Explains All This video explains how the code works, how to use it, and how to get the code and put it into your own …

Read moreFinding Missing Numbers in a Range Using VBA
Excel Factor 8 Highlight Cells Containing Formulas

Excel Factor 8 Highlight Cells Containing Formulas

August 3, 2012 by Mynda Treacy

This Excel Factor tip was sent in by Shannon Hommel of the UK. If you’re setting up a template or a workbook for other’s to use and you can’t password protect it (for whatever reason), then the next best thing is to highlight the cells containing formulas. This is not only an Excel ‘Best Practice’, …

Read moreExcel Factor 8 Highlight Cells Containing Formulas
list sheet tab names with vba

List Sheet Tab Names with Excel VBA

May 10, 2012 by Mynda Treacy

As I promised last week, today’s tutorial is a dead easy macro that will allow you to extract a list of your worksheet tab names. You can then use this list to: Create an index of your worksheets. Why not add Hyperlinks so you can quickly navigate your workbook. Or use them to create references …

Read moreList Sheet Tab Names with Excel VBA
  • Previous
  • Go to page 1
  • Interim pages omitted …
  • Go to page 7
  • Go to page 8
  • Go to page 9
  • 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
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

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.