How to Show a userform from XLA sub

  • Thread starter Thread starter Thibault
  • Start date Start date
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.
 
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.


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide
Click to expand...
to creating financial statements
 
Back
Top