Need help on checking spelling in textbox placed in userform!

[2588pillai]

Hello,

I am not an expert, but a beginner in excel, stuck here now! I have created a textbox in a userform and need to know how to do the spell check for all the text boxes in the form using a command button click?

Please help.

Thanks/Aju

 

[2588pillai]

Any experts to help!?

 

[tygrrboi]

Does this work?

Dim cCont As Control

For Each cCont In Me.Controls
    If TypeName(cCont) = "TextBox" Then
        Application.CheckSpelling(cCont.Text)
    End If
Next cCont</pre>

 

[2588pillai]

Does this work?

Dim cCont As Control

For Each cCont In Me.Controls
    If TypeName(cCont) = "TextBox" Then
        Application.CheckSpelling(cCont.Text)
    End If
Next cCont

Thanks, but unfortunately that did not make any change to the sheet! (I have two text boxes "ObservationTextBox1" & "ActionTextBox1")

Any other way to do that?