Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color cell if spell check finds an error
This may be very simple and I am totally over looking it, or tricky. I want
to somehow spellcheck all of the cells and if spellcheck finds an errors than those cells will be highlighted permantly until I unhighlight them. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color cell if spell check finds an error
Select the cells and run this small macro:
Sub spellcolor() For Each r In Selection If Application.CheckSpelling(r.Value) Then Else r.Interior.ColorIndex = 6 End If Next End Sub This only colors the cells, it does not bring up the dialog. -- Gary''s Student - gsnu200765 "LiveUser" wrote: This may be very simple and I am totally over looking it, or tricky. I want to somehow spellcheck all of the cells and if spellcheck finds an errors than those cells will be highlighted permantly until I unhighlight them. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color cell if spell check finds an error
Thank you Gary''s Student. It worked well.
If you don't mind or have time. Could you explain how this works within Visual Basic? "Gary''s Student" wrote: Select the cells and run this small macro: Sub spellcolor() For Each r In Selection If Application.CheckSpelling(r.Value) Then Else r.Interior.ColorIndex = 6 End If Next End Sub This only colors the cells, it does not bring up the dialog. -- Gary''s Student - gsnu200765 "LiveUser" wrote: This may be very simple and I am totally over looking it, or tricky. I want to somehow spellcheck all of the cells and if spellcheck finds an errors than those cells will be highlighted permantly until I unhighlight them. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color cell if spell check finds an error
Usually from the worksheet, spell check runs across may cells, stopping only
if it find a problem. The way we are using it, we get the contents of the individual cells and tell spell check to only check that string. Used in this fashion spellchecker only give back a TRUE/FALSE, without the correction dialog. Based upon the response, we color the cell the text came from. -- Gary''s Student - gsnu200765 "LiveUser" wrote: Thank you Gary''s Student. It worked well. If you don't mind or have time. Could you explain how this works within Visual Basic? "Gary''s Student" wrote: Select the cells and run this small macro: Sub spellcolor() For Each r In Selection If Application.CheckSpelling(r.Value) Then Else r.Interior.ColorIndex = 6 End If Next End Sub This only colors the cells, it does not bring up the dialog. -- Gary''s Student - gsnu200765 "LiveUser" wrote: This may be very simple and I am totally over looking it, or tricky. I want to somehow spellcheck all of the cells and if spellcheck finds an errors than those cells will be highlighted permantly until I unhighlight them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell check / character cell limit | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Error Msg 400 - Macro Spell Check | Excel Discussion (Misc queries) | |||
How can I protect a cell and keep the spell check working? | Excel Discussion (Misc queries) | |||
Spell Check an Unlocked Cell in a Protected Spreadsheet | Excel Worksheet Functions |