View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Shaka215@gmail.com is offline
external usenet poster
 
Posts: 162
Default 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