Spell check

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top