initialize userform

Add-in Express™ Support Service
That's what is more important than anything else

initialize userform
addin startup 
Dan Hetherington




Posts: 5
 Joined: 2015-03-11
Hi,

hopefully an easy one!
I'm working to converting myself from some amateur level coding from vba to using vb, so learning on the fly- I've got addin express to help me to transition a vba project in excel - just wondering where code should be added to load all the windows userforms associated with the addin at start-up of excel/ the addin load (as I need to keep data loaded in the forms through the use of excel).

many thanks for any help on this!

Dan
Posted 13 Apr, 2015 04:35:52 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Hello Dan,

A VBA project is a mixture of things that can be done using a COM add-in and Excel UDF. Plus, it may include data. What you need to do is to determine what Excel extensions you need to develop in order to replicate the functionality your VBA project implements.

Dan Hetherington writes:
just wondering where code should be added to load all the windows userforms associated with the addin at start-up of excel/ the addin load


I don't understand this. I can imagine an add-in loading a System.Windows.Forms.UserForm as a task pane. I'm not sure that you talk about such a user form.


Andrei Smolin
Add-in Express Team Leader
Posted 13 Apr, 2015 05:02:05 Top