Spell checking in user forms

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.

Related posts:

  1. Pop up Style Forms in Excel
  2. Pausing Excel
  3. Validating file names

Comments

  1. ross says:

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

  2. Excelent resolution!

    If you know ‘n’ others solutions, please go to
    my Blog too:

    VBA Office: http://inanyplace.blogspot.com/
    VB Excel: http://brzexceldeveloper.blogspot.com/
    VBA Access: http://brzaccessdeveloper.blogspot.com/

    Sincerely

    André Luiz Bernardes
    http://al-bernardes.sites.uol.com.br/
    bernardess@gmail.com

    Twitter: @officespecialis
    @brzexceldevelop
    @brzaccessdevel

Submit a Comment