Simple VBA Global Delorations?

[Chris]

Hi All

I am trying to write a series of functions in VBA for Excel 97.
I want to declare a series of constants (calculated by trigonometry within
module) at the start of my module for use throughout all the functions.
Can I do this and how?
( I tried to declare them as const but I got an error on the trig
functions.)

Thanks

Chris

 

[Tom Ogilvy]

A constant is not calculated. You can use a public variable.

Public MyTrigVal1 as Double

Sub InitMyTrigVal1()
MyTrigVal1 = SomeTrigFunction
End Sub

The trick is when do you want InitMyTrigVal1 to be run. Call it from the
workbook_Open event?

See Chip Pearson's page on Events
http://www.cpearson.com/excel/events.htm