LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default How to change add-in object from within worksheet module.

W dniu środa, 10 grudnia 2014 22:40:34 UTC+1 użytkownik GS napisał:

One way is to have your addin create menus at startup so you can
access its functionality at any time. Note that it's necessary to
delete any custom menus at shutdown so as not to modify Excel's TLB
file.


Hi Garry, thx for the answer.
I know the "menu way" to run anything by clicking the button.
My problem is different. I need to change for example the label
caption which is located on the add-in form. I hope this picture
would explain what do I want:
http://s12.postimg.org/opxcn5a4t/exc.jpg

Regards
Archidamos


You have set a reference to the VBA project and so you can only access
what you see listed in Object Explorer. Normally, this does not include
userforms!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


 
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
Worksheet_Calculate code in same module as Worksheet Change eventgoes astray Harold Good Excel Programming 4 December 18th 09 06:59 PM
Run procedure in stored in module on worksheet change event Daniel Jones Excel Programming 5 August 8th 09 10:11 PM
Pass worksheet object name to a class module [email protected] Excel Programming 1 May 9th 07 12:48 PM
Range object and worksheet change event Paulymon Excel Programming 3 September 26th 06 08:06 AM
Run worksheet module code from workbook module? keithb Excel Programming 1 August 14th 05 04:04 AM


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

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

About Us

"It's about Microsoft Excel"