Userform input to control two diferent workbooks

Y

yspin

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,
 
J

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top