View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Spell checking a TextBox


Simplest way would be to use a worksheet to pass your textbox value to -
spellcheck & then return corrected text back to textbox.

Something like following may work:

Private Sub CommandButton1_Click()
' use Sheet Range A1 to spell check text
With Sheets("Sheet1").Range("A1")

.Value = TextBox1.Text

.CheckSpelling

TextBox1.Text = .Text

.Value = ""

End With


End Sub
--
jb


"Patrick C. Simonds" wrote:

Is there any way to spell check the text in a UserForm TextBox when the user
exits the TextBox?