AN exception has occured error

**djsouljah** · 09-13-2013, 11:58 AM

Hey guys,

I really can't find a solution to this one.

I have a spreadsheet that has a macro with a userform that works great..Nothing wrong with it UNTIL i leave the file on the side for approx. 10 mins...Then for some reason, as soon as I run the userform, there's an error that pops up "An exception has occured" entitled "microsoft forms"..THe only thing I can do at this stage is change the name of the employee in one of the comboboxes I have in the userform...Other than that, anything I click makes this error come in the way.

I don't get how come it works great for 10 minutes and then I always have to close excel completly as it won'T let me do any manipulations in the userform.

FYI: I did check online for this type of issue and found that this issue arises when there's a sheet that's protected but I don't have any protected sheets ...See link here : http://www.ozgrid.com/forum/showthread.php?t=23336

HELP

?

THanks guys!!

**liz5818** · 09-13-2013, 02:46 PM

Did you check to make sure that you don't have anything hidden as far as worksheets?

**djsouljah** · 09-13-2013, 03:27 PM

Hey I actually figured it out..Basically the issue was happening because I had input data in the control source and at the same time there was a macro pulling up data from a table for the same combobox which caused a conflict...by removing the control source the error seams to have disapeared.

Thanks for your help