Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting control on userform with part of control name (set question) | Excel Programming | |||
Textbox input control? | Excel Programming | |||
Sum values from diferent workbooks | Excel Worksheet Functions | |||
Input Control | Excel Worksheet Functions | |||
Control Sequence from Userform Control | Excel Programming |