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.

--

Regards

Sri

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

"Sri" wrote in message
...
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.

--

Regards

Sri