LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Change Event.....Spell Check

Hi All..............

I am trying to create/record a macro that will automatically start the Spell
Checker on a cell as soon as data is entered into it.

I have a large cell created by merging many cells (A63:g69) to form a NOTES:
box at the bottom on one of my sheets. Many of my users can't spell, and I
would like the SpellChecker to pop up as soon as they hit Enter after typing
in that cell, but would like to restrict it to only checking THAT one
cell-range,.............right now it wants to check the whole sheet, even
the cells in hidden columns..........

Here's what I've got so far...........

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$63" Then
Range("A63:G69").Select
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _
, AlwaysSuggest:=True, SpellLang:=1033
ActiveWindow.ScrollColumn = 1
Application.EnableEvents = True
End If
End Sub

Any help would be appreciated..........

Vaya con Dios,
Chuck, CABGx3



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you change the font in the pop up spell check box? skoeske Excel Discussion (Misc queries) 0 November 20th 08 08:34 PM
Spell Check Sarapu New Users to Excel 1 October 16th 07 07:39 AM
Spell Check Mishka Excel Worksheet Functions 1 March 1st 07 08:51 PM
Spell check sri Excel Discussion (Misc queries) 1 February 6th 07 09:36 PM
... Can I set Spell Check to automatically check my spelling ... Dr. Darrell Setting up and Configuration of Excel 0 March 21st 06 08:26 PM


All times are GMT +1. The time now is 11:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"