Declaring variables: VB.NET Vs. VBA?

[JRCHAPMAN]

In VB.NET, a variable is declared using the syntax

Dim Foo As Integer = 10

I have just discovered that in VBA this does not work, and must instead be written as either

Dim Foo As Integer
Foo = 10

or as

Foo = 10

Is the second of these an acceptable way of declaring a variable? If not, what problems might be encountered if the datatype is not specified?

 

[Kyle123]

Foo isn't an integer in the second, it's a variant. This is the same as not declaring your variables and all the pitfalls that come along with it.

 

[nikio8]

Speaking of this same thing,

I have a function
Function addOne(i as int) as int
AddOne = i+1
End Function

In sub
Dim j as int
j=addOne(j)

Error. Type mismatch. Why would this happen?

 

[Kyle123]

That's not the same thing, please start your own thread