Class related Stuff Userforms

[DocAElstein]

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


UserForm Rory did for me.JPG
[code][color=black]'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,
[color=darkgreen]'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