Possible? Declaring variables of the same nature on one line

[mtheriault2000]

Hello

Learned from user: mikerickson That it is not a good habit to declare variable of the same nature in one line.
http://www.mrexcel.com/forum/showpost.php?p=2872811&postcount=3

I used to declare variable of the same nature like

Dim T1, T2, t3 As string

Mike learned me that in fact, I declare

T1 as variant
T2 as variant
T3 as string

Is there a way to declare same type variables on one line?

Martin

 

[Richard Schollar]

Hi Martin

Long-hand route:

Dim T1 As String, T2 As String, T3 As String

 

[VoG]

Try like this

Dim T1 As String, T2 As String, t3 As String

 

[mtheriault2000]

Thanks Peter, Richard

Will go to bed a little less "dummer "

Martin

 

[pgc01]

Hi Martin

Not that I'm a fan of these, but just to complete the options, 2 more:

1 - You can use a type-declaration character. These are suffixes you add to the variable name that define its type. For ex., for a string it's the "$". Ex.:

Dim T1$, T2$, T3$

2 - if you are really consistent in naming variables (as you should) you can also define type prefixes. For ex., in my case, I always prefix a string variable name with the letter "s". In this case I could (but I don't) define de "s" as a prefix for strings at the beginning of the module and use it in the variable declarations. Ex.:

Option Explicit
DefStr S
...
Dim sName1, sName2
...

As I said, I'm a fan of neither of these 2. I use the "As" syntax.