• 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

quickly formatting markers for dot plots

Quickly Formatting Markers for Dot Plots

November 22, 2018 by Philip Treacy

Mynda wrote a post about line charts vs dot plots where one of the steps in setting up the dot plot was to format the series markers, by hand 🙁 . Not surprisingly we had a few people ask if there was a quicker way to do this formatting, and Mynda volunteered me to write …

Read moreQuickly Formatting Markers for Dot Plots
web scraping multiple pages

Web Scraping Multiple Pages from Websites

October 24, 2018 by Philip Treacy

My last post looked at web scraping using VBA, where I loaded a single page and extracted content. In this post I'm looking at loading multiple pages from a site and getting the content I want from each page. Related Topics Web Scraping – Filling in Forms Web Scraping With VBA Let's say I want …

Read moreWeb Scraping Multiple Pages from Websites
web scraping with vba

Web Scraping With VBA

October 17, 2018 by Philip Treacy

We can use VBA to retrieve webpages and comb through those pages for data we want. This is known as web scraping. This post will look at getting data from a single web page. I've written another post that deals with getting data from multiple web pages. Related Topics Web Scraping – Filling in Forms …

Read moreWeb Scraping With VBA
remove formatting from a table

Remove Formatting from a Table

September 19, 2018 by Philip Treacy

Let's say you have a range that you want to convert to a table Something like this that has fills, font colors, font weight, borders and number formats. If you convert this to a table this formatting remains. To remove this formatting and preserve the table formatting, we can use some VBA code. Download the …

Read moreRemove Formatting from a Table
listing and deleting custom styles

Listing and Deleting Custom Styles

September 11, 2018 by Philip Treacy

If you end up with a workbook that contains custom styles, removing all of these may be a pain depending on how many there are. With a little VBA we can easily list and delete all custom styles. In my workbook I have three custom styles, Cool Style 1, Gaudy Style and Sunglasses Required. The …

Read moreListing and Deleting Custom Styles
calling vba in an add-in from another vba module

Calling VBA in an Add-In From Other VBA Modules

July 3, 2018 by Philip Treacy

If you've written subs or functions in your own add-in, you can use them in your worksheet as you would with any other sub/function. Subs can be called using shapes or buttons, the QAT, the Ribbon, or from the list of macros brought up by ALT+F8. Functions can be called by typing the function name …

Read moreCalling VBA in an Add-In From Other VBA Modules
timer stopwatch in excel vba

Timer or Stopwatch in Excel VBA

April 19, 2018 by Philip Treacy

We had a post on the forum recently asking how to create a timer in Excel, to record how long things took to happen on a model railroad. You can use the same code to time anything of course, like how long your code is taking to execute. A follow up request asked for code …

Read moreTimer or Stopwatch in Excel VBA
volatile user defined functions

Volatile User Defined Functions

April 13, 2018 by Philip Treacy

Excel has the concept of volatile and non-volatile functions. Microsoft define a volatile function as one that is recalculated every time calculation occurs in any cell in the worksheet. There's actually a bit more to it than that but for the sake of keeping it simple we'll go with that definition. A non-volatile function is …

Read moreVolatile User Defined Functions
writing udfs in excel with python

Writing UDFs in Excel With Python

November 24, 2017 by Philip Treacy

My last post looked at using Python to plot equations in Excel with DataNitro. In this one I want to look at writing UDFs in Python.with xlwings. Why Use Python for UDFs ? This is a question not just about UDFs but why use Python at all in Excel? I guess this depends on what …

Read moreWriting UDFs in Excel With Python
excel 4 macro functions

Excel 4.0 Macro Functions

October 26, 2017 by Philip Treacy

Before VBA there were XLM macros. VBA was introduced in Excel version 5, so these Excel macros are also known as Excel 4 macros. Even though these XLM macros are quite old they still work in Excel 2016. To use them you call them like a regular function e.g. =GET.CELL(64,A1) but entering this into a …

Read moreExcel 4.0 Macro Functions
  • Previous
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to page 5
  • Interim pages omitted …
  • Go to page 9
  • Next
  • 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.