or a workbook name

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sharad" wrote in message
...

Well, then another way to do it could be write the variable in a cell in
a worksheet. With this you even need not declare the variale as public,
simply do Dim variable1.
Select an isolated cell in the worksheet and name the cell as say
"ufVar1".
In the form code, where ever this variable is being assinged a value,
immediately below you can add

Range("ufVar1").Value = variable1

But you need to add above line, below each line in form code where
'variable1 =' appears.

In the sheet you can now use ufVar1 as variable e.g.
formula in a cell : = ufVar1

In the module you can use the variable as Range("ufVar1").Value

Sharad

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