If you want the variables to be recognized in two different procedures
at module level, the variables must be declared as public variables, out
side any procedu
This can be done in any module. For examaple the module (1 or 7) should
look like below:

Public myNumber As Integer, myString As String
Public '...more public declarations

Sub MyCode()

'code

End Sub.

So define the vairables as Public (not Dim) and define them outside any
Sub procedure.

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!