PDA

View Full Version : Customised spell check in VBA



SLS7
08-02-2017, 09:12 AM
Hi everyone,

I am a newbie and I have a generic question, if you can point me to the right direction that would be perfect
I need to create a customised dictionary in excel, maybe using vba as mostly data I receive comes with misspellings or just shortened like cse for case, blk for for black and etc. Ideally I would like to have a customised list that I can updated when needed. I have a huge list so far to upload in bulk but will be adding words to the list from time to time. Is it possible, if so could you suggest any source to read/watch/etc?

Thanks a lot

Logit
08-02-2017, 07:08 PM
.
Don't recreate the wheel.



Option Explicit
Sub chkSpell()


'//Add to ThisWorkbook
'//Brings up UK Spell Check before closing


Cells.CheckSpelling SpellLang:=2057 '//UK Spellcheck
'//Cells.CheckSpelling SpellLang:=1033 '//US English Spellcheck

'// looking for list of langauge codes
'// will post in comments when i find a list

End Sub