Class related Stuff Userforms

**DocAElstein** · 12-26-2018, 04:27 PM

Some old notes, recovered / repaired from here
https://www.excelforum.com/excel-pro...n-on-open.html
7 May 2016 up to about the 11 May, then possibly the original Problem and Solution Summary , beefed up a bit after the thread Help Understanding Class Instancing. Can't Set ws = New Worksheet. Intellisense offers that went from 11 May to 16 May. The last edit on the original of all this was on the 19 May, (but I may have messed the last posts up a bit)

This is what I got. Rory did it for me
UserForm Rory did for me.jpg UserForm Rory did for me.jpg

UserForm Rory did for me.JPG

Code:

'Static fm As ufResults  ' instead of this I have it as a Global variable so that i can check it elsewhere, and I add it and check a box on opening the file
'Dim fm As ufResults ' This would result in the UserForm "Dieing" a t every code ending
    If Fm Is Nothing Then Set Fm = New ufResults ' if this line was not yet done, then a new instance of the class ufResults with the name fm is made
    If Not Fm.Visible Then Fm.Show False 'make sure UserForm is always there,
'Start of Part only done for entry in the three C column Ranges and no check for Calculate all else. --  Things here are that can be done quickly, 1 "row" stuff!!                  http://www.excelforum.com/showthread.php?t=1107695&p=4380613&highlight=#post4380613