LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform won't show when file re-opened Gerry O Excel Discussion (Misc queries) 2 September 4th 07 05:42 PM
Properties window show nothing for a userform Cheer-Phil-ly Excel Discussion (Misc queries) 0 July 27th 06 07:15 PM
Create and show UserForm from Add-In Rick Knight[_2_] Excel Programming 3 December 9th 03 01:04 AM
Userform.hide / show papou[_7_] Excel Programming 0 September 15th 03 03:12 PM
show a userform Joe[_17_] Excel Programming 0 July 18th 03 03:25 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"