Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Show a userform from XLA sub
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. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Show a userform from XLA sub
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" wrote in message ... 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. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform won't show when file re-opened | Excel Discussion (Misc queries) | |||
Properties window show nothing for a userform | Excel Discussion (Misc queries) | |||
Create and show UserForm from Add-In | Excel Programming | |||
Userform.hide / show | Excel Programming | |||
show a userform | Excel Programming |