Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.Value(Variable)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.Value(Variable)
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 "David" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.Value(Variable)
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 "David" wrote in message ... 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.Value(Variable)
Maybe you are thinking of
Application.WorksheetFunction.Value Marcotte |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.Value(Variable)
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. -- Regards, Tom Ogilvy "Marcotte A" wrote in message ... Maybe you are thinking of Application.WorksheetFunction.Value Marcotte |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
application.Value(Variable)
So I gave you a way to do it.
-- Regards, Tom Ogilvy "David" wrote in message ... 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 "David" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
macro to close excel application other than application.quit | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming | |||
application.quit will not shut off application | Excel Programming | |||
Excel application: Summing several terms (some constant, some variable) | Excel Programming |