Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting Userform
Can I start a UserForm from another workbook and eventually even
have the workbook with the UserForm hidden? Regards Mats |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting Userform
"Mats Samson" wrote in message
... Can I start a UserForm from another workbook and eventually even have the workbook with the UserForm hidden? Hi Mats, Yes. The standard way to do this is to make the workbook containing the UserForm an add-in (set the IsAddin property of its ThisWorkbook object to True in the Properties Window). You can then create a procedure in the add-in that shows the UserForm and call this procedure from any other workbook you like. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting Userform
Hi Mats,
One way: In Book1: Sub MyUserform Userform1.Show End Sub Hide Book1 '==================== In Book2: Sub Test Application.Run "Book2!MyUserform" End Sub --- Regards, Norman "Mats Samson" wrote in message ... Can I start a UserForm from another workbook and eventually even have the workbook with the UserForm hidden? Regards Mats |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting Userform
Hi Mats,
When replying, I did not see that you already had a response from Rob Bovey. --- Regards, Norman "Mats Samson" wrote in message ... Can I start a UserForm from another workbook and eventually even have the workbook with the UserForm hidden? Regards Mats |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting Userform
Thanks guys,
you solved my problem! Best regards Mats "Mats Samson" wrote: Can I start a UserForm from another workbook and eventually even have the workbook with the UserForm hidden? Regards Mats |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Starting userform | Excel Programming | |||
Starting a userform upon starting the file | Excel Programming |