Function Val("1") not working

[mtheriault2000]

Simple code to transfer a string number to a number as long is not working.

Dim v as long
v= val("12")

 

[Marcelo Branco]

Xenou,

Tks very much for your wonderful explanation.

I had never thought about Excel accessing his own functions, like Left, Right etc, in different libraries.

Reading your post i'm wondering if you were "not really the kind to have technical answers at my fingertips" who else could be...

Tks again

M.

 

[xenou]

Reading your post i'm wondering if you were "not really the kind to have technical answers at my fingertips" who else could be...

someone else who's been involved in this thread ... with a name starting with m ...

ξ

 

[Marcelo Branco]

someone else who's been involved in this thread ... with a name starting with m ...

ξ

(nothing to say lol..)

 

[Norie]

You shouldn't need to add VBA in front of these sort of functions.

There's also another reason, perhaps more common, that causes this behaviour - missing references.

You can check for that under Tools > References...

 

[RoryA]

Without a "can't find project or library" error, I'd guess someone has created an additional Val function somewhere, in which case adding 'VBA.' is a perfectly good resolution, IMO.

 

[Norie]

Looks like I misread, I thought other functions weren't being recognised too

Still, seems a bit strange to rewrite something like Val.

Might have it's uses though, perhaps it does something with the expected array/table/whatever.

 

[mtheriault2000]

Hello

Thanks to all
V= VBA.Val("12") did do the job

- I did check the priority for VBA and it was in the first place

I'm working on a complex system and new libraries as been added. It is very plausible that one of them as a VAL function that interfered with VBA.VAL.

I did learn something here....

Martin

 

[Norie]

Martin

You might be able to find out where this other Val comes from if you check the Object Browser.

Obviously only I've you've got the time.

 

[mtheriault2000]

Martin

You might be able to find out where this other Val comes from if you check the Object Browser.

Obviously only I've you've got the time.

Thanks Norie

Excuse my ignorance, but how do i access the Object Browser.

Martin

 

[RoryA]

Open the VBEditor and press f2.