Class related Stuff Userforms

[DocAElstein]

https://www.excelforum.com/excel-pro...ml#post4382657
https://www.excelfox.com/forum/showt...ll=1#post24171

---

Still struggling here.

Can anyone help

_......




Possible a User Form expert may see that I am missing something fundamental ? .

I am still not able to get anything other than False when using debug lines ( which I have at the points where I want to use such a check )

StatusDeBuger:   Dim v: v = ufResults.OptionButton2.Value: Debug.Print "ufResults.OptionButton2.Value "; v

EresDeBuger:     v = ufResults.Refresh.Value: Debug.Print "ufResults.Refresh.Value "; v

The full story is given, and the File is linked, in the previous posts

Here again I give the relavent parts of the Worksheet_change code
( Apologies again that I can not simplify this code and test data. As mentioned before this is particularly difficult in this case to do )

Towards the start I have this, which appears to make the User Form come up

Static fm As ufResults
    If fm Is Nothing Then Set fm = New ufResults
    If Not fm.Visible Then fm.Show False 'make sure UserForm is always there,

Then a bit further down I have this DeBug Line

StatusDeBuger:   Dim v: v = ufResults.OptionButton2.Value: Debug.Print "ufResults.OptionButton2.Value "; v

Towards the end of the code I have a line which puts the contents of an Array into a list in the User Form

    fm.lstResults.ColumnCount = UBound(ArrDisplaySP(), 2): fm.lstResults.List = ArrDisplaySP(): fm.Repaint

Shortly after that I have my second Debuger line

EresDeBuger:     v = ufResults.Refresh.Value: Debug.Print "ufResults.Refresh.Value "; v

Thank you
Alan

P.s. The File Link again, details about it, how to use it etc.. in first post

https://app.box.com/s/fpztob9pcp92fl6hh81zgpzumw9ntcp0