View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default I get error 91 when trying to run Bullen's FormFun

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