remote userform control
 

i am trying to write to a userform in workbook-B from a macro i
workbook-A.

it was correctly suggested to me to pass the values to the macro a
arguments, and then use those values as properties in the userform.

from macro in workbook-A:
application.run "workbook-B.xls!that_macro", 4,8

from macro in workbook-B:
sub that_macro (a,b)

this method has a limit of '30' arguments that you can pass along
turns out the userform i am filling out in workbook-B has more tha
(30) blank "textboxes" and "checkboxes". how can i pass mor
arguments?

LIMITATIONS:
I trying really hard not to alter workbook-B much at all. i ca
continually write macros to workbook-B but i do not want to write t
any worksheets in workbook-B.

?can i 'piggie-back' macros, one after another, to fill in the userfor
in workbook-B?
please help

--
tad_wegne
-----------------------------------------------------------------------
tad_wegner's Profile: http://www.excelforum.com/member.php...fo&userid=2777
View this thread: http://www.excelforum.com/showthread.php?threadid=47309