Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to load/show UserForm from other Workbook
Hi all,
I have a problem to load or show my userform in book1, but all I want is open it from book2 via VBA Is there way except call the macro in book1 from book2 I want it open from book2 directly .. Thanks if you help me... Rgds, halim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to load/show UserForm from other Workbook
Create a subroutine in Book1.xls's project that shows the userform:
Option Explicit sub showtheform() userform1.show end sub Then in Book2.xls's project, you can call that subroutine: option explicit sub ShowTheFormFromBook1() application.run "'" & "book1.xls" & "'" & "!showtheform" end sub wrote: Hi all, I have a problem to load or show my userform in book1, but all I want is open it from book2 via VBA Is there way except call the macro in book1 from book2 I want it open from book2 directly .. Thanks if you help me... Rgds, halim -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform to load when Workbook is opened | Excel Programming | |||
Userform Question (Load/Unload/Show/Hide) | Excel Programming | |||
LOAD userform | Excel Programming | |||
UserForm Wont Load | Excel Programming | |||
Load a Userform | Excel Programming |