Build a Smart Excel Combobox

Like most things in life, Excel VBA users mature as they write code overtime. Every time we search the internet for a vexing VBA problem we learn something. Of course, I hope you take the time to look at more than one solution because there may others that are better or more appropriate.  In this […]

Dynamic Gantt Charts

Dynamic Gantt ChartsCreating Dynamic Gantt Charts using VBA shapes allows you infinite control over the output and to add custom touches.  https://youtu.be/HJjv-9ZTNXMIf you were able to utilize what you learned here or improve the code, please leave a comment HereIf you enjoyed this post or found it helpful and would like to say hello and […]

Excel Web Scraping Custom Function Builder

The clients request was simple I want to pull the following financial statistics from the Wall Street Journal and Market Watch:1) Name form Ticker Symbol2) Total Revenues3) Non Operating Interest Income4) Total liabilities He was nice enough to provided the URLS as follows: The Wall street Journalhttps://www.wsj.com/market-data/quotes/AAPL/financials/annual/balance-sheet Market Watchhttps://www.marketwatch.com/investing/stock/AAPL/financials/balance-sheet/quarter” I did the job and built […]

Custom Excel Worksheet Protection

The scene was repeated far too many times: We sent out our Excel forecast single worksheet workbooks to the various divisions with specific instructions:  Do not change anything, do not add rows or columns.  Just input your forecast.  Simple right?  Invariably about 10PM when we ran our consolidation it failed. https://youtu.be/nC3a-1ROW3U Why? because a division […]

Excel Audit Trail

The client called with a query: “I am trying to figure how I can make the attached spreadsheet highlight with yellow fill any change made by the user after the sheet is refreshed. The idea is the user would refresh the data from our database and if they wanted to make a change they would make […]

Excel Status Forms – Keep your User informed

You have just spent the last three days perfecting a killer dashboard for Maximum Trucking Inc.  It reaches out to 8 different site data sources.  The graphics are spot on and identify trends and emerging issues.  You run it again to test the final version and realize it takes over two Minutes to run.  No, […]