Runtime error -2147417848 (80010108) Disconnected from client

Hi guys,

I have created a userform via Excel 2010, which is made up of 5 userforms. On each form there are numerous textboxes and checkboxes and a couple of listboxes, which assist the user in writing a report.

Basically each selection generates various phrases and words onto the excel spreadsheet, which also uses formulas when various cells are filled with data on the spreadsheet, in addition to simple & formulas to assist in creating full sentences (i.e. if 2 checkboxes are selected then one cell will show 'and' as opposed to a full stop).

On the last userform there is a button to open a word document and the coding pastes data from the spreadsheet into bookmarks on the document, subsequently writing a full report for someone.

I had tested this for a while and it worked well, but I have recently made a few changes by adding some more checkboxes and removing some of the errors (i.e. the checkboxes generating the wrong words and/or phrases). Now when I run it I get Runtime error -2147417848 (80010108) Disconnected from client when either selecting checkboxes on userform 2, or when pressing continue (which just open the next userform).

I have looked at various forums for ideas of how to fix it, but havent found anything that I can associate with my userform. Any help on how to fix it would be greatly appreciated. I have attached my tool for reference.

Many thanks,

Chris

Update:

I get this error:

Error.JPG

And then upon pressing debug I get this:

debug.JPG

Hi xlnitwit, my apologies for not warning you!

So you would recommend using option buttons as opposed to check boxes?

Many thanks

Hi,

Yeah I've used checkboxes because there are occasions, where the user will select more than one.

The clear buttons are used to clear the data up to that point, so that is the intention of those buttons.