VBA - Userform new instance

Question

So I have a main userform where I do all my calculations and I want to display them on my image forms. I tried to use:

Dim newInstance As New diagramGUI
newInstance.Show vbModeless

but then I cant access the data from the main userform. Is there any workaround for this?

TinMan · Accepted Answer · 2018-07-05 08:41:34Z

3

You need to add a public variable in the diagramGUI userform to point the the instance of MainUserForm.

Add this line to the diagramGUI code module

 Public Controller as MainUserForm

Then set the reference from the MainUserForm after you instantiate then new diagramGUI

 Dim newInstance As New diagramGUI
 Set newInstance.Controller = Me
 newInstance.Show vbModeless

answered Jul 5, 2018 at 8:41

TinMan

7,8142 gold badges13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1