Return value from another form   

Hi

how can i using VBa return a value from another form. The form will be 
hidden.

Regards

D

date: Wed, 3 Sep 2008 10:12:45 +0100   author:   DMc2007

Re: Return value from another form   

DMc2007 wrote:
> how can i using VBa return a value from another form. The form will be
> hidden.

Expose a public property and query it before destroying the instance...

   Public Property Get ReturnValue() As Long
      ReturnValue = whatever
   End Property

-- 
.NET: It's About Trust!
 http://vfred.mvps.org

date: Wed, 3 Sep 2008 16:00:22 -0700   author:   Karl E. Peterson