Episode 778 - Interative TextBox
One of my favorite tricks is to fill a textbox with the result of a formula in the worksheet. When you try this as the title in an embedded chart, you need to change the formula to point back to the original worksheet. Episode 778 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!