Customised spell check in VBA

[SLS7]

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]

.
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