How to Show a userform from XLA sub

T

Thibault

Hi everybody,

I'm trying to show a userform from an XLA addin. The userform is
defined within a regular XLS project.

I have tried:
Userform1.show
VBA.UserForms.Add("userform1").Show

But I get 424 error

Of course Userform1.show works when called from a Sub in the XLS
project where the userform is defined.

Thanks for any Idea.

Regards.
 
C

Chip Pearson

Create a procedure in the XLA called ShowTheForm and then call
that procedure from the XLS file.

[in the XLA]
Public Sub ShowTheForm()
Userform1.Show
End Sub

[in the XLS]
Application.Run Filename.xla!ShowTheForm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



Thibault said:
Hi everybody,

I'm trying to show a userform from an XLA addin. The userform is
defined within a regular XLS project.

I have tried:
Userform1.show
VBA.UserForms.Add("userform1").Show

But I get 424 error

Of course Userform1.show works when called from a Sub in the XLS
project where the userform is defined.

Thanks for any Idea.

Regards.
Click to expand...
to creating financial statements
 
Top