S
serdar
like:
define PI 3,14
define PI 3,14
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dr. Stephan Kassanke
S
serdar
thanks a lot, saved my 15min checking this on the net.
S
serdar
I get this error:
Compile error:
Constants not allowed as Public members of object modules
But this works:
Const PI = 3.14
...then what is the scope of above declaration, the module it is declared?
Compile error:
Constants not allowed as Public members of object modules
But this works:
Const PI = 3.14
...then what is the scope of above declaration, the module it is declared?
B
Bob Phillips
How about using Excel's built-in value
worksheetfunction.Pi
--
HTH
RP
(remove nothere from the email address if mailing direct)
worksheetfunction.Pi
--
HTH
RP
(remove nothere from the email address if mailing direct)
S
serdar
im not using it for PI, it was an example sorry for confusing.
E
Earl Kiosterud
Serdar,
Const PI = 3.14 would have module-level visibility.
Public Const PI = 3.14 should work at the module level (above the subs and
functions). Regular module only. It works in XL 2002, English. It has
public visiblilty. Press F1 with the cursor on Const for help.
Const PI = 3.14 would have module-level visibility.
Public Const PI = 3.14 should work at the module level (above the subs and
functions). Regular module only. It works in XL 2002, English. It has
public visiblilty. Press F1 with the cursor on Const for help.
S
serdar
Using XL 2000 and public constant declaration causes error i defined
previously (above subs and functions).
Currently i dont need public scope so thats ok for me but i am curious why i
get that error message in XL 2000.
previously (above subs and functions).
Currently i dont need public scope so thats ok for me but i am curious why i
get that error message in XL 2000.
N
Norman Jones
Hi Serdar,
What type of module are you trying to use the declaration in?
As Earl has already indicated, the declaration can only be used in a
standard module; it cannot be used in a sheet module, the ThisWorkbook
module or a userform code module and an attempt to use it in these modules
will produce the error you describe
What type of module are you trying to use the declaration in?
As Earl has already indicated, the declaration can only be used in a
standard module; it cannot be used in a sheet module, the ThisWorkbook
module or a userform code module and an attempt to use it in these modules
will produce the error you describe
S
serdar
thats ok it was a sheet module, sorry. thanks.
haber iletisinde þunlarý said:Hi Serdar,
What type of module are you trying to use the declaration in?
As Earl has already indicated, the declaration can only be used in a
standard module; it cannot be used in a sheet module, the ThisWorkbook
module or a userform code module and an attempt to use it in these modules
will produce the error you describe