Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I googled this and seems like it should check AK15, which it does, but if spelling is correct it moves on to other items on the sheet. And of all things the next "item" it checks for spelling is the text on a forms button "C. Fmt."
(Fmt not in Dict... suggest FM) The Msgbox and Exit Sub are my idea of what I would like the code to do. If spelling in AK15 is correct, tell me and when I click OK it goes away. Thanks, Howard Sub SpellIt() With Range("AK15") Call .CheckSpelling("CUSTOM.DIC", False, True, 2057) 'Msgbox "Spelling is correct" ' Exit Sub End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet | Excel Programming | |||
Spellcheck plus Locking | Excel Discussion (Misc queries) | |||
From single cell variables to a single column serie | New Users to Excel | |||
Spellcheck | Excel Discussion (Misc queries) | |||
Spellcheck via VBA in excel? | Excel Programming |