MS EXCEL User Forms - Text Box Object - Text Spelling 1

[hafod]

Hi,
Ive programmed an existing spreadsheet application to use an Excel User Formform as a means of user friendly data access (like Forms in MS Access)with good data validation across a range of data types. The forms works fine and I can successfully add/delete/amend undeling 'Field' data. However, one 'Field', the comment field - txtComments.Text requires to be spell checked by the user before the entry/change is comitted. Can I call up a routine, maybe a Windows call to do this ? Is this possible because there is no obvoius access to this facility - despite reading Excel VBA books!. This feature IS important because external reports will be generated when the data is subsequetly exported to the host system for output. I am using Excel2002 SP3
Hope you can help!
Many thanks
Mike

 

[taupirho]

Try the following:-

If (Application.CheckSpelling(txtComments.Text) = True) Then
MsgBox ("spelling OK")
Else
MsgBox ("spelling error")
End If

 

[hafod]

Hi Tomreid
Many thanks for your helpful suggested code - works fine! Much appreciated.
Best regards,
Mike