Using Excel VBA to Control Office Thumb

Using VBA to control other Office applications

Whilst this site is primarily about using Excel, there are times when Excel is not the best tool for the job.  Each Office application is designed for different tasks.  Tables and charts may be easily prepared in Excel, but they are often exported to PowerPoint, Word or Outlook for the purposes of presentation and distribution.  Read More

Change number format based on value

Change number format based on a cells value

Imagine a situation where you have built a dynamic report or dashboard that you a really proud of.  The user can make selections through a drop-down box and the report updates automatically, it’s a beautiful thing.  There is just one issue with these types of dynamic reports/dashboards – not all the information is of the Read More