Run time error 75 (Path/File Access Error) - Excel 2007 on XP SP3

Hi

Having a Run time error 75 (Path/File Access Error) on a sheet with a userform.
I am running Excel 2007 on XP SP3

I tried search and found this thread:
http://www.excelforum.com/excel-prog...s-error-3.html

I updated the SP3 and reinstalled Excel and the sheet keeps giving the same problem so I am wondering if itīs something to do with the code.

The sheet works fine and the userform does exactly what I want it to do, but after a while if I leave it and return to it and I start the userform again I just get the error.

When I click debug it goes to the second line of the following code:

Please Login or Register  to view this content.

When I right click "Show Object" on the userform it says Path not found.
When I right click on "Show Code" on the userform I get the code.

This has been happening frequently.
Is there anything from the code that could be causing this?

See attached the sheet. Itīs not a long piece of code.

Thanks in advance.

Thanks for the thread. It is an ugly fix alright.

I am using the unload code when resetting the userform and also when calling it from the macro prior to calculations because the form is referencing a cell on a sheet that might be changed.

Is there any other way to quickly reset all textbox /combo boxes once the calculations are done?

(Or a Solution to the actual problem)

Thanks for taking the Time.

I have now removed all the unload commands from the userform and am putting the UserForm1.TextBox1.Value = ""... directly in the Private Sub CommandButton2

I need to test some variations of this code and see if it stops the crashing.
From what I can gather this is an issue common only to the Excel 2007 + Win XP combo, so it seems to be a bug in the system.

Iīll let you know if this workaround works.

Thanks again