textbox spell check
On May 7, 8:13 pm, "Ray" wrote:
how can i spell check a textbox on a userform in an Excel macro.
TextBox1.CheckSpelling "CUSTOM.DIC", False, True, 1033
does not work
and this form
A = Application.CheckSpelling(cWords, CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False)
just tells me if the word id good or not.
Ray
Try this...
Inside of your spell check button on the userform...
Sheets("Sheet1").Range("A1").Value = TextBox1.Value
Sheets("Sheet1").Range("A1").Select
Application.CheckSpelling
TextBox1.Value = Sheets("Sheet1").Range("A1").Value
It's worked for me in the past...hope it works for you =)
~Shaka
|