Monthly Archives: February 2014

The Amsterdam Excel Summit

Originally posted on Excel and UDF Performance Stuff:
A Unique Opportunity Dear Excel lovers, Is Excel the first and last application you use every day? Do you want to improve your Excel skills and get first-hand knowledge from the absolute…

Posted in Microsoft Excel | Tagged , | 1 Comment

VBA: Four Ways To Change Variable Values In Break Mode

Zack’s recent post over at Excel & Access Experts got me thinking: how many ways are there to change a variable’s value in break mode? Needing no further excuses to give Cropper a try, here’s what I came up with. … Continue reading

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

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