application.Value(Variable)

[David]

Hi Group,

Brought in a text value via InputBox, "NoWks", which I am
trying to make into a value. Done this before, but am
using 2003, maybe something has changed?

Immediate window:
?application.value(NoWks)
Get message "wrong number of arguments"

Thanks

 

[Tom Ogilvy]

As far as I know there is no Application.Value. What do you expect to get
from

application.Value(NoWks)

is NoWks a variable that holds a value?

NoWks = InputBox("Please enter a number")

if so,

? cdbl(NoWks)

or
? clng(NoWks)

 

[David]

i am trying to turn the text into a value, number.

-----Original Message-----
As far as I know there is no Application.Value. What do you expect to get
from

application.Value(NoWks)

is NoWks a variable that holds a value?

NoWks = InputBox("Please enter a number")

if so,

? cdbl(NoWks)

or
? clng(NoWks)

--
Regards,
Tom Ogilvy




.

 

[Guest]

Maybe you are thinking of
Application.WorksheetFunction.Value

Marcotte

 

[Tom Ogilvy]

if he was, it makes no difference. Neither

application.Worksheetfunction.Value or
application.Value are valid

This is one worksheet function that isn't supported in VBA.

 

[Tom Ogilvy]

So I gave you a way to do it.