You need to Set the clsFormChanger to a new instance of the
CFormChanger class. E.g.,
Set clsFormChanger = New CFormChanger.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"kurb" wrote in message
...
Hello
Thanks to Stephen Bullen for FormFun
I am having problems setting it up
I inserted CFormChanger Class Module in my project
I get run time error 91: Object variable...not set
when I run UserForm_Activate
Private Sub UserForm_Activate()
Dim clsFormChanger As CFormChanger
clsFormChanger.ShowMinimizeBtn = True 'Error 91 here
clsFormChanger.Sizeable = True
clsFormChanger.ShowIcon = False
Appreciate any suggestions
K