Excel - Creating a Watch Window & Watch Box in Excel | Dueling Excel - Episode 1488

4,462 views · Published 9 December 2011 · 9:42 · Indexed 1 November 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial - Creating a Watch Window & Watch Box in Excel | Dueling Excel.

Welcome to another exciting episode of Dueling Excel, where we pit our Excel skills against each other to see who comes out on top. I'm Bill Jelen, also known as MrExcel, and I'm joined by Mike Girvin from ExcelIsFun. In this episode, we're tackling the topic of Watch Windows in Excel, and we're teaming up to defend Excel's honor against a claim that you can't have a Watch Box in Excel. 

We were inspired by a great series by Larry, "15 Things You Can't Do In Excel For Budgeting," and we noticed that number 4 on his list was a Watch Box. But we knew that Excel does have a Watch Window, and we were determined to show that it is possible to have a Watch Box in Excel. So, we're teaming up to show you how to set up a Watch Window and a Watch Box in Excel. 

Mike will be demonstrating how to set up a Watch Window, which allows you to monitor specific cells and their formula results as you make changes to your spreadsheet. It's a great tool for budgeting and tracking data. And I'll be showing you how to create a Watch Box using VBA, which is a bit more complex but still achievable for those who are comfortable with coding. 

We'll also be sharing some tips and tricks along the way, like how to name cells using the keyboard shortcut CONTROL+SHIFT+F3 and how to create a modal user form for your Watch Box. And we'll even show you how to add some extra flair to your Watch Box by using different colors and formatting options. So, join us as we defend Excel's honor and show you how to set up a Watch Window and Watch Box in Excel. Thanks for watching and don't forget to subscribe to our channel for more Dueling Excel episodes. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Teamwork to defend Excel's honor
(00:14) Larry's blog series on Watch Window limitations
(00:31) Bill's rebuttal
(00:45) Mike demonstrates setting up a Watch Window
(01:00) Mike's "freaky" method for naming cells
(01:56) Adding a Watch to the Watch Window
(02:51) Customizing the Watch Window
(03:47) Bill's alternative method using VBA
(04:11) Bill's Watch Box demonstration
(05:10) Creating a Watch Box using VBA
(09:23) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Adding a watch
Creating a Watch Box with VBA
Excel's honour
Larry's Watch Box
Modifying the Watch Window
Naming cells
Set up a Watch Window
ShowWatch and Worksheet Calculate
UserForm and labels
Watch Window
Watch Window in Formula Auditing


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153165/

Microsoft Excel Duel
In today's Dueling Excel, Episode #1488,  Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen team up to defend Excel's honor, showing two different methods to create a Watch Box in Excel.

Dueling Excel Podcast #92...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

"Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

More from this channel