Spell check

[Guest]

Hi,

I am developing a mini application form, wherein users will input some
lengthy details in the textboxes available. They would also copy & paste from
somewhere..

To make it clean, i want to do a spell check on the values they have typed
in the textboxes...

I know excel has the option of spell check for the sheets, but not sure if
its possible in VBA.

Can anyone please help me in doing this.

Thanks.

 

[L. Howard Kittle]

Hi Sri,

Try this, from the macro recorder and modified slightly. Where Dum is the
range of cells you entries are in.

Sub Macro2()
Dim Dum As Range
Set Dum = Range("A1:a10")
Dum.CheckSpelling SpellLang:=1033
End Sub

HTH
Regards,
Howard