Posted: Light Box Demo
I just posted a workbook that demonstrates how to get a "light box" effect in Excel. You've probably seen Web sites that use this technique when displaying images or pop-ups. Now you can do it in Excel. I tested it with Excel 2003 and 2007.
The workbook has an empty UserForm with a black background. That UserForm is resized to match Excel's window dimensions, and an API function gives it a transparent look. Then, another UserForm (or message box) is displayed on top.
It's pretty simple, and it works well -- but not perfectly. On my system, there's an annoying flicker before the lights go out. If anyone can figure out how to avoid that, please let me know.
Download it here: Light Box Demo.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.