Like or not like...

[ReneMiner]

really nosy today, another question about LIKE this time.

There's some grey fading indicaction of memory in my head that LIKE would work with STRING-expression and variables - so copies the type of the variable.

As this

Dim A As Long
Dim B Like A ' B would be Long now

but somehow it does not work. Did it work once- or did i just dream this? Has it been changed? Is it broken?

[ErosOlmi]

Hi Rene,

I'm too confused some time. Too options
LIKE accept a string expression that will evaluate into a type expressed as a string.

So options are:

Dim a As Long
Dim b As a
Dim c Like "long"
Dim d Like "lo" & "ng"

[ReneMiner]

ahhhh... i just messed it up because it was introduced together i guess. So nothing is broken except my memory