Tag Archives: Locals window

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

VBA: What Type Are Your Constants?

In the previous post we saw a common mistake when declaring VBA variables and used the Locals window to show that variables are Variant types unless you specify otherwise by using: As Type in the declaration, eg. Dim strHello As String A type … Continue reading

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

A Common Mistake When Declaring Variables In VBA

For today’s post I’d like you to imagine that you’re an up and coming VBA programmer who is starting to feel at home with the IDE and language. You’ve read about some VBA best practices which has made you aware of the … Continue reading

Posted in .Net, Microsoft Excel, Microsoft Office, VB .Net | Tagged , , , , , , | 10 Comments