Tag Archives: Auto Data Tips

A Guided Tour Through The VBA IDE’s Options

The VBA Integrated Development Environment provides a limited set of options under Tools > Options which will let you customise the environment for your own personal needs. Microsoft hasn’t added anything new to this part of MS Office for many years … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , , , , , , | 8 Comments

VBA Auto Data Tips

Auto data tips are a very handy feature when you’re debugging VBA code. You may have noticed that when you’re stepping through code, if you hover your mouse over, for example, a property, then you get a pop-up window showing its value. … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , | 5 Comments