Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a userform
In the project code module I want to call a userform. ProcessChoices is the
name of the form. SSPproject is the name of the Project. I tried: Public Sub ProcessChoices() SSPproject.ProcessChoices Load End Sub It doesn't work, how do you load a form? thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a userform
Are you trying to open a form in a spreadsheet (or addin) from another
spreadsheet or addin? If so then you need to either create a reference to the project where the form is in the spreadsheet that is trying to load the form. Tools - References -SSPproject. Call SSPproject.LoadProcessChoices Or you can use Application.Run("SSPproject.LoadProcessChoices") In either cases in the SSPproject you need to add a procedure to load the form. The procedure needs to reside in a regular code module. Public Sub LoadProcessChoices() ProcessChoices.Show end sub -- HTH... Jim Thomlinson "Janis" wrote: In the project code module I want to call a userform. ProcessChoices is the name of the form. SSPproject is the name of the Project. I tried: Public Sub ProcessChoices() SSPproject.ProcessChoices Load End Sub It doesn't work, how do you load a form? thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a userform
Never mind, I figured it out. It has been one of those days.
"Janis" wrote: In the project code module I want to call a userform. ProcessChoices is the name of the form. SSPproject is the name of the Project. I tried: Public Sub ProcessChoices() SSPproject.ProcessChoices Load End Sub It doesn't work, how do you load a form? thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a userform
This is weird. What I did works except you can't close Excel afterward. You
have to force quit. Thanks I'll try your idea. "Jim Thomlinson" wrote: Are you trying to open a form in a spreadsheet (or addin) from another spreadsheet or addin? If so then you need to either create a reference to the project where the form is in the spreadsheet that is trying to load the form. Tools - References -SSPproject. Call SSPproject.LoadProcessChoices Or you can use Application.Run("SSPproject.LoadProcessChoices") In either cases in the SSPproject you need to add a procedure to load the form. The procedure needs to reside in a regular code module. Public Sub LoadProcessChoices() ProcessChoices.Show end sub -- HTH... Jim Thomlinson "Janis" wrote: In the project code module I want to call a userform. ProcessChoices is the name of the form. SSPproject is the name of the Project. I tried: Public Sub ProcessChoices() SSPproject.ProcessChoices Load End Sub It doesn't work, how do you load a form? thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to call-up UserForm | Excel Worksheet Functions | |||
How to call a sub from UserForm Module | Excel Programming | |||
Using cell name to call userform | Excel Programming | |||
Problem with Blocking Dynamically generated UserForm Call | Excel Programming | |||
Is it possible to call a UserForm multiple times? | Excel Programming |