UPDATE!

If you downloaded the example file, you may have noticed that it didn’t quite work properly - somehow a line of code had gone missing - I’ve updated the example file now so it should work ok.

———————

I have a report file I send to colleges, I don’t want it to look like “just another spread sheet”, so I’ve put some strong formatting and images in, when I’m ready I send it out as a PDF. It’s quite nice a looks good. There is a bit of a problem. Part of the report is made up of a set of merged cells, I used this space to add a few sentences, but typing like this in Excel is a bit of a pain.

To make the process a bit simpler I knocked up a simple user form, in which I can type in a more naturally way, I can spell check it right there in the form and them send the whole lot back to an excel range, cool!

I think this implementation of the spell checker falls somewhere between the one suggested by Dick, and Jons [see here].

Anyway here is a demo file.