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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920