Avoiding Variants: Multiple Declarations per Line Assign Variants To All But Last Variable

When I declare a set of variables in Microsoft Excel's VBA Version 15.0 as such:

Please Login or Register  to view this content.

...I notice in my Locals Window that i & j (or any variables except the last variable declared as any datatype) are variants; however, k is declared as type: Integer.

When I step through my code, I see i & j change from: Variant/Empty to Variant/Integer as I assign integers to i & j. Since they're variants, I can also assign other datatypes to i & j.

QUESTION: Is there any way to declare multiple variables per line of the same datatype without a long-winded: Dim i As Integer, j As Integer, k As Integer?

I thought Dim i, j, k As Integer declared all i, j, and k as Integers and now I'm about 10,000 lines deep into a project I'd rather not retrace through for that. Hoping for some kind of Application.Magic command.

Thanks in advance,

Joe

As far as I know the only way is to use what you already know:
Dim i As Integer, j As Integer, k As Integer

Please Login or Register  to view this content.

What do you mean by "I'd rather not retrace through for that"
It is only one declaration to do at the beginning and finally you can use the VBA editor to manage changes

Hi Joe

See this Link...
http://www.cpearson.com/excel/declaringvariables.aspx

From that Link..

Pay Attention To Variables Declared With One Dim Statement

VBA allows declaring more than one variable with a single Dim statement. I don't like this for stylistic reasons, but others do prefer it. However, it is important to remember how variables will be typed. Consider the following code:
Dim J, K, L As Long


You may think that all three variables are declared as Long types. This is not the case. Only L is typed as a Long. The variables J and K are typed as Variant. This declaration is functionally equivalent to the following:
Dim J As Variant, K As Variant, L As Long


You should use the As Type modifier for each variable declared with the Dim statement:
Dim J As Long, K As Long, L As Long

I take it one step further and declare a single variable per line. That gives the opportunity to add an end-of-line comment that describes usage.

Isn't there some 'archaic' way to setup how variables are typed by default based on their name?

"That gives the opportunity to add an end-of-line comment that describes usage. "
It is perhaps an "'archaic' way" ( coming from the previous century ) but it is clear, simple and force developer to document
and it does not cost so much.

PCI

I wasn't commenting on your post, I just seem to recall that there was some way in VBA to have variables automatically typed.

Perhaps I'm mistaken.

https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx

Hi Norie

I played with the Link you referenced and this definitely appears to work...Locals Window returns the proper Data Types.

Not certain how I'd use it as yet but I'd appreciate any feedback.

Please Login or Register  to view this content.

And this appears to work...

Please Login or Register  to view this content.

And this appears to work...

Please Login or Register  to view this content.

Originally Posted by Norie

https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx

Norie, I'm shocked. Shocked. Ugh.

Originally Posted by jaslake

Not certain how I'd use it as yet but I'd appreciate any feedback.

Here's some John: It's horrible.

Unless you write code for your own entertainment, it's a miserable thing to do for the guy that follows you in the parade with the shovel and bucket.

Joe,

Originally Posted by joe31623

.....
QUESTION: Is there any way to declare multiple variables per line of the same datatype without a long-winded: Dim i As Integer, j As Integer, k As Integer?....

Not quite what you want but a little bit better.... ... just a bit less typing

Instead of

Dim i As Integer, j As Integer, k As Integer?.

then the "shorthand" alternative

Dim i%, j%, k%


http://www.excelforum.com/excel-prog...ml#post4194972



Alan

P.s. I personally would write most Declarations on one line, and add 'comments to the right to explain what they are.
I do not think it takes much time to do that, and space / memeory is cheap for code lines, and later you ( or as shg said....the guy that follows you in the parade with the shovel and bucket.....) would be very greatful you did...

Also the 'comments in the VB editor, like in the Code window at ExcelForum go off to the right and are not too messy in the final code,- so you only see them if you want to and scrol to the right

@shg

I also use this approach...

I take it one step further and declare a single variable per line.

Thanks for the feedback as my bucket has a hole in it...

shg

I'm not suggesting using that method.

@Norie

Yeah, I got this...

I'm not suggesting using that method

From these comments...

Isn't there some 'archaic' way to setup how variables are typed by default based on their name?

and this

I wasn't commenting on your post, I just seem to recall that there was some way in VBA to have variables automatically typed.

I frankly wasn't aware of this method and found it interesting...so I followed up and tested. It appears to work...

I'll likely not use it but am now aware it exists, for whatever "archaic" purpose. Thank you for that and adding to my education.

Originally Posted by Doc.AElstein

then the "shorthand" alternative

Dim i%, j%, k%

If you're down to you last 5kB of disk space, which is the only excuse for that, consider a GoFundMe drive for 50 bucks to get a new one.

Originally Posted by shg

If you're down to you last 5kB of disk space, which is the only excuse for that, consider a GoFundMe drive for 50 bucks to get a new one.

or maybe consider a free code storing facility:

http://www.mrexcel.com/forum/excel-q...ml#post4074287
http://www.mrexcel.com/forum/excel-q...ml#post4078702

Originally Posted by shg

..........
Unless you write code for your own entertainment, it's a miserable thing to do for the guy that follows you in the parade with the shovel and bucket.

Originally Posted by Doc.AElstein

.......
P.s. I personally would write most Declarations on one line, and add 'comments to the right to explain what they are.
I do not think it takes much time to do that, and space / memory is cheap for code lines, and later you ( or as shg said....the guy that follows you in the parade with the shovel and bucket.....) would be very grateful you did.......

Originally Posted by jaslake

@shg
I also use this approach...
Thanks for the feedback as my bucket has a hole in it...

Translation across the Pond for English viewers...

Originally Posted by shg

I take it one step further and declare a single variable per line. That gives the opportunity to add an end-of-line comment that describes usage.

_ Not doing the above form of Declaration is like giving the Bloke who has to Shovel S___ uphill a Rake.


Edit: Of course I meant Sand