Excel Off The Grid Logo
    • Home
    • Blog
    • Courses
    • Books
    • Need Help?
    • About
    • Contact

    Category: Blog

    Tab color from cell thumb

    Change tab color based on a cell value in Excel

    Posted on February 12, 2018April 19, 2018 by Excel Off The Grid

    Wouldn’t it be great to change the color of a worksheet tab based on a calculation?  If you’re not convinced, here are some possible scenarios: When a schedule reconciles or includes a specific cell value If there is an error in a range of cells To color code tabs to match a contents page You Read More

    Posted in Blog, Formulas, VBA
    VBA-Code-Snippets-Thumb

    Run a macro from a macro (from another workbook)

    Posted on February 10, 2018April 19, 2018 by Excel Off The Grid

    In VBA, there are several ways to run a macro within a macro, and even run a macro from another workbook.  On forums these methods are used interchangeably, which can lead to confusion for others, as depending on the method for running/calling the macro, the syntax is slightly different. This post shows these common methods Read More

    Posted in Blog, VBA, VBA Code Snippet
    Color Picker VBA thumb

    Calling and using the color picker with VBA

    Posted on February 5, 2018April 19, 2018 by Excel Off The Grid

    When building Excel-based tools and applications it is often useful for the user to select a color.  Whilst it is possible to build a custom UserForm, Excel’s native Color window is more than suitable for most circumstances. Excel’s native color picker: To show the Color window, you might think we could use the Macro Recorder, but Read More

    Posted in Blog, Tips & Tricks, VBA
    Quick Excel Tips Thumb

    Quick Excel Tips [1]

    Posted on January 29, 2018April 19, 2018 by Excel Off The Grid

    Sometimes it is the small things which make the biggest differences.  The following tips are small, some of them very small, but they might save you a lot of time and a lot of annoyance.   Quick Excel Tip #1 If the formula Tooltip box is in the way, you can move it.  Click on Read More

    Posted in Blog, Tips & Tricks
    Excel Auto Resize Thumb

    Auto resize an Excel spreadsheet to fill the screen

    Posted on January 22, 2018April 19, 2018 by Excel Off The Grid

    Every office I have ever worked in has been an equipment battleground.  It didn’t matter what the equipment was; it just had to be better than everybody else.  A new keyboard, a bigger screen, even a mouse mat with a wrist rest was enough to make everyone else jealous.  I was once lucky enough to Read More

    Posted in Blog, Dashboards, Tips & Tricks, VBA 5 Comments
    Excel FILES Function Thumb

    Excel function to list files in a folder without VBA

    Posted on January 15, 2018April 19, 2018 by Excel Off The Grid

    Listing the files in a folder is one of the activities which cannot be achieved using normal Excel formulas.  I could tell you to turn to VBA macros or PowerQuery, but then any non-VBA and non-PowerQuery users would close this post instantly.  But wait!  Back away from the close button, there is another option. For Read More

    Posted in Blog, Formulas, Tips & Tricks 2 Comments
    VBA-Code-Snippets-Thumb

    VBA Code to control Excel’s Zoom settings

    Posted on January 11, 2018April 19, 2018 by Excel Off The Grid

    Excel has zoom settings for worksheets, UserForms and print settings.  Each of these serves different purposes and used at different points, but they can all be controlled by VBA.   Worksheet zoom settings The worksheet zoom setting in Excel will always be an integer.  If the value set by VBA contains decimal places it will Read More

    Posted in Blog, VBA, VBA Code Snippet
    Step Chart Thumb

    How to create a step chart in Excel

    Posted on January 8, 2018April 19, 2018 by Excel Off The Grid

    A step chart is used to show data which changes at specific points, then remains consistent until the next change occurs.  Interest rates set by central banks across the world follow this system.  Some dudes in suits meet together on a particular day and decide the rate should change.  That change happens instantly and remains Read More

    Posted in Blog, Charts
    Review 2017 Goals 2018 Thumb

    2017 Review & 2018 Goals

    Posted on January 1, 2018April 19, 2018 by Excel Off The Grid

    The John Lennon song Happy Xmas (War is Over) has been playing almost every hour on UK radio for the past month.  At the start of December the lyrics “Another year over, and a new one just begun” seemed slightly premature.  But, as I write this it is the end of December the New Year Read More

    Posted in Blog, Miscellaneous 2 Comments
    VBA-Code-Snippets-Thumb

    VBA code: check what is currently selected in Excel

    Posted on December 22, 2017April 19, 2018 by Excel Off The Grid

    Often we want to determine what type of object has been selected in Excel. It helps with error checking prior to running a piece of code.   Basic code This action is just a just a single line of code: Sub testSelection() MsgBox TypeName(Selection) End Sub   Incorporate the check into a Select statement If Read More

    Posted in Blog, VBA, VBA Code Snippet
    Posts navigation
    Older posts →
    ← Newer posts

    Excel Courses

    Free Excel Dashboard Webinar

    Top Excel Book

    Advertisements




    Gift ideas for Excel lovers

    Gift ideas for Excel lovers nerds and geeks

    • Follow me on social media

      Follow @exceloffthegrid

      Save

    Theme by Out the Box
    • Home
    • Terms and conditions
    • Privacy policy
    • Affiliate disclosure
    • Contact