Duplicate Object Name Lockup

  • Thread starter Thread starter John Wilson
  • Start date Start date
J

John Wilson

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
 
BrianB,
Yes, been there, done that lots of times.
Click to expand...
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.
Click to expand...
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
 
Back
Top