be the expert in your office
A blog focused primarily on Microsoft Excel, PowerPoint, & Word with articles aimed to take your data analysis skills to the next level. Learn anything from creating dashboards to automating tasks with VBA code!
The default formats of Userforms have not been updated since the 1990’s and it is very unfortunate since UI design has changed quite a bit since then! In this article, I am going to walk you through how to transform those outdated grey userforms into fresh and current dialogs. Enjoy!
Read MoreIn this article you will learn how to use Excel’s built-in InputBox dialog to allow your users to write-in or select a cell range. This range can then be used throughout the remainder of your executable VBA code.
Read MoreLearn how to create a hover-over effect for your VBA Userform buttons. This format changing effect will allow you to match Microsoft’s current dialog box UI (user-interface) design.
Read MoreThis guide will provide you with all the critical VBA snippets you’ll need to know in order to interact with ListBox controls within your userforms.
Read MoreLearn how to easily make your personal macro file reappear if it happens to disappear on you.
Read MoreDoes your screen go crazy and start flickering or flashing every time you run your macro? Learn how to prevent this nuisance from happening (and speed up your code in the process!).
Read MoreLearn how to prevent an Excel Error message that will prompt while the Excel Application is opening, stating it cannot find an add-in that was deleted from your computer.
Read MoreIn this article I will show you how to vertically (middle) align the text in your Excel userform textbox controls. Unfortunately, there is no built-in button to do this….so we have to get a little creative!
Read MoreLearn how to find and remove external links from your Excel spreadsheets.
Read MoreIn this article, you will learn how to determine what you user currently has selected before attempting to modify the spreadsheet with your VBA code. This will prevent errors and potential irreversible devastation to the spreadsheet your VBA code will be running on.
Read MoreIn this article, you will learn the steps needed in order to save a single PowerPoint slide or all of your PowerPoint slides into image files.
Read MoreIn this article you will learn how to use VBA to automate creating and maintaining a PowerPoint multiple choice quiz from using data stored in Excel.
Read MoreLearn how to get rid of the Excel error message pertaining to, "Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."
Read MoreI reveal my methodology for keeping track of different types or groups of shape so they can be easily modified in bulk later on.
Read MoreStay on top of your Christmas spending this year and use my personal Excel template to track all your expenses and stay within your budget!
Read MoreLearn how to fix weird spacing in your Excel print margins
Read MoreOne instance where merging cells is more favorable than centering across
Read MoreAs Microsoft continues to persuade people to sign up for their Office 365 subscription in lieu of purchasing individual copies of Office, I am hoping that the Office team moves towards sending out more updates on a regular basis (similar to how Google does with their Chrome browser).
Read MoreLearn how to re-order Excel Slicer button into any order you please.
Read MoreI've gone ahead and created this post to round up some of the best quality courses currently available on topics like creating dashboards, mastering Pivot Tables, and figuring out how to write custom VBA code.
Read MoreBecome an expert in Excel, PowerPoint, Word, and the rest of the Microsoft Office Suite. Check out all the free tutorials and VBA code snippets!
Create Excel, PowerPoint, Word add-ins with ease with this revolutionary template and online course!
Affiliate Program | About | Example Files
Guru Solutions, LLC | © 2015-2019 | ALL RIGHTS RESERVED
Excel, PowerPoint, Word, & the rest of the Office Suite are registered trademarks of the Microsoft Corporation
This site is not affiliated with Microsoft Corporation.
