none
VBA Frozen while creating Userform RRS feed

  • Question

  • While creating a Userform in Excel VBA, I was changing the Name of a command button. I accidentally clicked elsewhere on the page while the "Name" field was either empty or had illegal characters in it. An error dialog box appeared that says the following: Not a legal object name: " (it included that quotation mark, which may have been what I had accidentally typed into the Name field). The problem is that everything is frozen now. When I move my cursor over the Visual Basic window, or over the Excel Spreadsheet window, it appears as a black circle-with-a-slash and I cannot click anything. I'm afraid to close it Excel or VBA entirely since I haven't saved my work very recently. Any suggestions?
    • Moved by Kee Poppy Monday, November 7, 2011 7:01 AM (From:Visual Basic General)
    Saturday, November 5, 2011 11:34 PM

All replies