Across Excel Workbooks in VB

[q4s72534]

Do you kwno what is the way to define the variable project wide....

 

[Loomah]

Basically delare the variable as Public outside any procedures, within a module. For example in module1

Option Explicit
Public myVar As String

Then in module2 and sheet1 module you may have the following code respectively which will pick up the declaration of the variable from module1.

Option Explicit

Sub a()
myVar = Format(Now, "hh:mm:ss")
MsgBox myVar
End Sub

and

Option Explicit

Private Sub Worksheet_Activate()
myVar = Format(Now, "hh:mm:ss")
MsgBox myVar
End Sub

Hope this helps!
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244