Spell checking in user forms

Posted on Monday 6 March 2006

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.


2 Comments for 'Spell checking in user forms'

  1.  
    Roger Wray
    18 January 2008 | 1:02 am
     
  2.  
    18 January 2008 | 11:13 am
     

    Hi,
    Add a referance to the office obect libary, I will update the download too.
    Thanks
    Ross

Leave a comment

(required)

(required)


.

Use [VBA] Your Code [/VBA], when posting code, cheers Ross x /


RSS feed for comments on this post | TrackBack URI