Quick question......

Sometimes, by my own stupidity, I'll try to name an object on a
UserForm (Textbox, whatever) with the same name as another
object on the UserForm.

Doing so immediately results in a telltale "ding", a cursor with a
circle/slash and Excel locks up totally.

I've tried Ctrl+Break and all sorts of other key sequences but
the only thing that works is Ctrl + Alt + Del which causes me
to lose anything I've done since my last save.

Was just wondering if anyone else has run into this problem
and if there's a way out other than an ungraceful Excel exit.

I've already done my ungraceful exit for this instance but I'm
sure that I'll inevitably do it again someday.

Thanks,
John

Yes, been there, done that lots of times.

No other way of closing.

You 'forget' to save at your own risk. Hope you remember to back u
too.

If you *have* saved, of course the error remains and I often find tha
after deleting the line Excel still acts as if it is there. The onl
way out is to copy the whole module, paste into Notepad ("cleans" th
text) and copy/paste from there into a new module

--
Message posted from http://www.ExcelForum.com

BrianB,

Yes, been there, done that lots of times.
Was just wondering if I was the only one.

If you *have* saved, of course the error remains and I often find that
after deleting the line Excel still acts as if it is there.
Since it locks up instantly, I don't have to worry about that error
being saved. As for any others that I do save, Rob Bovey's
Code Cleaner always seems to do the trick.

Thanks,
John


"BrianB " wrote in message
...
Yes, been there, done that lots of times.

No other way of closing.

You 'forget' to save at your own risk. Hope you remember to back up
too.

If you *have* saved, of course the error remains and I often find that
after deleting the line Excel still acts as if it is there. The only
way out is to copy the whole module, paste into Notepad ("cleans" the
text) and copy/paste from there into a new module.


---
Message posted from http://www.ExcelForum.com/