Tom’s Tutorials For Excel: Showing And AutoClosing a UserForm
Sometimes you might want to only show a UserForm for a brief time, say 5 seconds. For example, you might want to show a quick message that’s custom-formatted beyond what a MessageBox can do, or you want the effect of a splash screen to advertise your work when the workbook opens.
…
Tom’s Tutorials For Excel: Using a Comment to Log Changes in a Cell
Tom’s Tutorials For Excel: Using a Comment to Log Changes in a Cell
Here’s an easy way to keep a running log of changes to a cell’s text.
Suppose you want your employees to enter an explanation or description of some kind into a cell regarding a topic on your spreadsheet.
…
Read more ›
Tags: Analytics, Big Data, Business Intelligence, Cells Ranges Lists, Comments / Screen Tips, Data Science, Excel Expert, Excel Guru, Macros Events Classes API, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis