close UserForm
Sounds like you have an error in your code where you try to use an object
that is not set to a reference. Probably in some code that fires when the
userform is closed.
for instances if you had
Private Sub Cmd_OK_Click()
rng.Value = Textbox1.Value
Unload me
End sub
if rng was not pointing to a range object, you would get such an error.
--
Regards,
Tom Ogilvy
" wrote:
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!
|