The code that you write for the controls on a userform can be used to open
and close multiple workbooks from the same user form. The form is simply a
means of organizing different controls on a single object so that it can be
displayed when needed and put away when no longer needed. What the form does
is all in the code that is used by the various controls.

"yspin" wrote:

Hi,

I am looking for a way of controling wo different workbooks from one
userfom.
the user opens a workbook and inserts inputs through the userform,
that then changes both workbooks (one was opened by the user).
how can i do that when only one workbook was opened?
is there any independent userform?

Thanks,