Without seeing the code in the UserForm_Terminate event, it is difficult to
determine the cause of the problem. In order to have the editor take you to
the offending line of code, in VBA go to the Tools menu, choose Options,
then the "General" tab. There, select "Break In Class Module" instead of
"Break On Unhandled Errors".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)

wrote in message
oups.com...
Received a runtime 91 error "Object variable or With block variable not
set" error when closing an user form. Excel debug go right to 'Load
UserForm1" statement. All code run smoothly up to this point.

Help!