remote writing to userforms

I am trying to write to a userform from a macro. Consequently, the userform is a part of a macro of another workbook (workbook-B).

I wrote a macro in workbook-A... it activates a macro in workbook-B. Part of workbook-B's subroutine opens a userform that requires addition info. I have the data to populate the userform, but do not know how to insert the data into the userform from the macro in workbook-A.

Anyone have any experience here?

You could pass the values to tye macro as arguments, and then use those
value as properties in the userform and load there.

Workbook A

Application.Run "WorkbookB.xls!that_macro", 4,8

Workbook B
Standard module

Sub that_macro(a,b)
Userform1.Value1 = a
Userform1.Value2 = b
Userform1.Show
End Sub

Userform

Public Value1 as Long
Public Value2 As Long


"tad_wegner" <[email protected]> wrote
in message news:[email protected]...
>
> I am trying to write to a userform from a macro. Consequently, the
> userform is a part of a macro of another workbook (workbook-B).
>
> I wrote a macro in workbook-A... it activates a macro in workbook-B.
> Part of workbook-B's subroutine opens a userform that requires addition
> info. I have the data to populate the userform, but do not know how to
> insert the data into the userform from the macro in workbook-A.
>
> Anyone have any experience here?
>
>
> --
> tad_wegner
> ------------------------------------------------------------------------
> tad_wegner's Profile:
> http://www.excelforum.com/member.php...o&userid=27770
> View this thread: http://www.excelforum.com/showthread...hreadid=472818
>