View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jamescox[_61_] jamescox[_61_] is offline
external usenet poster
 
Posts: 1
Default Spell Check in Text Boxes


Lee Ann -

This surprised the heck out of me, but in Excel 2007 when I recorded
the process of spell-checking one textbox and then played a bit more it
looks like this simple sub will do what you need:

Public Sub SpellCheckTextboxes()

Cells.CheckSpelling SpellLang:=1033

End Sub

It seems to start at Cell A1 and then works its way down and to the
right, looking for textboxes and spell-checking the text in them.

Please let me know if this works for you...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=120599