Debug Error 424 on UserForm Close

**Nu2Java** · 10-03-2012, 07:52 PM

Hello,

I have an attached UserForm here that I have been working on for awhile now and also learing from along the way. The form is working quite well for what I need but there is a problem I am running into when CLOSING the form when there is no data in it. I get a debug error 424 "Object Required". And it will not let me debug to see where it is failing, it just closes out the program.

If I search a job "A12345" and pull the data to form and update it... everything is fine. But just opening the program and clicking "X" and selecting "YES" to close, thats when the error happens. If "No" is selected, it closes the form and returns to the worksheet and all is ok.

Any help would be GREATLY appreciated! .... I am going NUTS with this.

**mike7952** · 10-03-2012, 08:08 PM

Me personally do not like Excel Application that hides Excel, but thats just me. Try moving frmMain.Show in the workbook_open from the top of your code to the very bottom.

**Nu2Java** · 10-03-2012, 08:20 PM

Thank you VERY much... that did the trick. I was not paying attention that it was trying to run that check on workbook_open. I totally agree with you on the hiding excel. I just have too many users that input data to this and the less they see, the less they can screw up.

Is there any way to be able to see where these errors come up?