by Anonymous (267 Submissions)
Category: String Manipulation
Compatability: Visual Basic 5.0
Difficulty: Unknown Difficulty
Originally Published: Fri 15th October 1999
Date Added: Mon 8th February 2021
Rating: (1 Votes)
Check Spelling Using Excel's Spell Checker
'txtspell Holds String You Want Checked
Set XlSpell = CreateObject("Excel.sheet")
Set XlSpell = XlSpell.application.activeworkbook.activesheet
XlSpell.Range("A1").Value = txtspell.Text
XlSpell.CheckSpelling
txtspell.Text = XlSpell.Range("A1").Value
Set XlSpell = Nothing
AppActivate Caption
End Sub