Need someone to look over my userform code as i keep getting error 361 for no reason

[uglymaggot]

Hey i created a userform that is fully functional it works great except randomly it gives an error no. 361 saying it cannot load or unload n i cant save or do any thing except exit.
there is also incomplete code where im trying to save my listbox entries to a txt file.

i will upload the worksheet


thanks in advance

[Norie]

Which userform are you having problems with?

[MarvinP]

Hi
I can't get to your code as I get error messages, but this sounds like a DoEvents type of problem. Insert DoEvents in your code to allow other windows operations to perform before coming back and trying to do the next step of code...

http://office.microsoft.com/en-us/ex...080557164.aspx

[uglymaggot]

sorry the username is Victory and the password is 2014

the problem is most likely with the case manager userform but it even popped up while i was in vba for no reason i guess.

how do i use the DoEvents im new to vba just picked it up as a project last month so forgive me if i seem lost
i would also like someone to check to see the integrity of the code i used or if i beat around the bush to get things done

[MarvinP]

You put DoEvents everywhere in your code where you are asking Excel to go out to the OS or other programs and do stuff. I'd put it directly after an Open command or something that takes up CPU time.

Look at http://www.mrexcel.com/forum/excel-q...ts-solved.html

[uglymaggot]

K thanks will try that
also i would really appreciate it if my code could be looked over just to see if its ok.
and how for the life of me do i save the contents of the listbox in a text file the code i had tried to do that was not saved as i could not save the excel file

[uglymaggot]

Im really not sure where to put the doevents
and how to save the listbox items to a text file

[uglymaggot]

*bump* sry for posting again

[Norie]

Do you have the option to Debug when you get the error?

If you don't try going to Tools>Options and selecting either Break on All Errors or Break on Errors in Code Modules on the General tab.

[uglymaggot]

hey ill give that a try

also sometimes if i input data when i double click the listbox it gives the wrong entry in the boxes to edit i do not know why? i really need someone to just check the code to see if it makes complete sense

thanks

[uglymaggot]

hey thanks Norie i was able to correct the 361 error

But im still getting trouble with the application overall as in if i select an entry by double clicking it in the list box it gets transferred to the text boxes below for me to edit but the data that gets transferred is not the same data i selected but a totally different entry i really dont know how to fix this as there is no error just a misleading line in the code i guess i could upload the code if that would help.

thanks for all the help hope we can find a solution to the problem