Userform input to control two diferent workbooks
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, |
Userform input to control two diferent workbooks
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, |
All times are GMT +1. The time now is 07:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com