Exit sub from user form problem...

**ChrisMattock** · 12-10-2008, 10:19 AM

Good morning all, I am having a small issue where I get a runtime error '91' when the Exit Sub command is used from a user form, this is what happens.

1. I run the macro which assigns some variables then shows UserForm1

2. On UserForm1 initialising and through use of a command button I sort though all of my data assigning tasks to each piece of data, this all works fine, however when there is no data left this piece of code executes:

Please Login or Register  to view this content.

Everything works fine until this point but when it hit's Exit Sub I have a problem. Any ideas what's going wrong?

**royUK** · 12-10-2008, 10:20 AM

You don't need exit sub, just unload me

**ChrisMattock** · 12-10-2008, 10:26 AM

That was an awesomely quick reply Roy! Thanks, but now I have removed it I get stuck in an endless loop (I can't even press escape the stop the macro now). When Unload Me is used from UserForm_Initialize where does it start running code from again? The original macro that called the form? If so then it goes back there and the form is called again, my MsgBox is displayed, it unloads, etc. etc.

**royUK** · 12-10-2008, 10:28 AM

I didn't realise it was part of a loop. maybe

Please Login or Register  to view this content.

**ChrisMattock** · 12-10-2008, 10:33 AM

Well that almost works, however after the form is unloaded it popus up again almost instantly, here is the initial part of the code...

Please Login or Register  to view this content.

Then this is what happens with UserForm1

Please Login or Register  to view this content.

The following just control the movement of items between two listbox's

Please Login or Register  to view this content.

Hope that makes sense, sorry not very good at this, but am assuming the problem occurs when I keep reloading the current form?

**royUK** · 12-10-2008, 10:50 AM

Replace Exit Sub with End

Please Login or Register  to view this content.

**ChrisMattock** · 12-10-2008, 10:51 AM

Yes, yes, yes! That's perfect, and so simple! +rep to you and thanks so much!

**royUK** · 12-10-2008, 10:54 AM

Thanks for the rep 7 glad it helped.

Exit sub from user form problem...

LinkBack

Thread Tools

Rate This Thread

Display

Exit sub from user form problem...

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions