VBA Etiquette: Dim all variables at the top of Sub or Dim as you Go?

[Bill Bisco]

When I was taught VBA, my instructor stated that we should always Dim all our variables at the top of the code. However, I see several examples of people "Dimming" variables as they go?

What is this board's opinion of the best practice of where and when to Dim Variables?

Thanks,

Bill

 

[starl]

And it comes with the added bonus of the fact that if you find yourself scrolling back and forth over a million lines to check your variable names, your code is too long, and it forces you to break it up into smaller functions and subroutines.

While I definitely vote for smaller routines, I found out a few months ago (thanks to Zack the Table King ), that if you select a variable and press Ctrl+I, it'll bring up the variable type! I used to split my window so I could keep the variables at the top, but then he showed me that trick.

 

[Peter_SSs]

select a variable and press Ctrl+I, it'll bring up the variable type!

Thanks. I didn't know that trick.

 

[dispelthemyth]

that if you select a variable and press Ctrl+I, it'll bring up the variable type!

Thanks, this can be quite useful and is something i was not aware of as im sure plenty of others weren't either.

I generally have the variable type in the name but sometimes i can forget e.g. bVariable1 for Boolean and sVariable2 for String