Bizarre Excel error

[Chris Dunigan]

Hello All,
I'm having major problems with a particular spreadsheet that i've
developed.
I have a button on one worksheet that opens a userform which contains
many comboboxes and textboxes. A button on the userform saves the
inputted information to a second worksheet. However before the
information is saved Excel shuts down, showing the "Microsoft Excel
has encountered a problem and needs to close. We are sorry for the
inconvenience." message.
The strange thing about this is that if once the spreadsheet is opened
i go into the vb editor and then close it down straight away the error
never occurs!
The vb code itself is not complex at all - has anyone heard of a
problem with excel that sounds similar to this???

any help would be appreciated.
the code can be supplied if necessary.

many thanks
chris dunigan

 

[Tom Ogilvy]

You might try using Rob Bovey's free code cleaner utility:

http://www.appspro.com go to free downloads.

It basically exports all your vbe components (code, userforms,etc) for you
workbook. Deletes them in the workbook, closes and saves the workbook, opens
it back up and imports the components back in. This can often clear up
"strange" behavior.

 

[Chris Dunigan]

thanks for the suggestion, but sadly it didn't work on this occasion.