![]() |
|
|
|
#1
|
||||
|
||||
|
Undoubtedly by using activedocument rather than the document names you have applied, the code is losing track of which document is which. The folllowing should address it:
Code:
Option Explicit
Private Sub cmdSpellCheck_Click()
DoSpellCheck TextBox1
MsgBox "Spelling and Grammar Check Complete"
lbl_Exit:
Exit Sub
End Sub
Public Sub DoSpellCheck(oTxtBox As Control)
Dim oDoc2 As Document
Dim oRng As Range
Set oDoc2 = Documents.Add
With oTxtBox
If Not .value = "" And Not .value = "<WhatEver>" Then
Set oRng = oDoc2.Range
oRng = .value
With oRng
.SpellingChecked = False
.CheckSpelling AlwaysSuggest:=True
.CheckGrammar
.End = .End - 1
End With
'Return data to the Userform
.value = oRng.Text
oDoc2.Close SaveChanges:=wdDoNotSaveChanges
End If
End With
Set oDoc2 = Nothing
Exit Sub
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
UserForm textbox exit event activated with navigation buttons...why? help?
|
orozvik@yahoo.com | Excel Programming | 2 | 05-08-2015 02:50 AM |
| Can't use RTF Textbox in Userform (Word2007) | dherr | Word VBA | 2 | 03-16-2015 07:50 AM |
Userform VBA Textbox Calculation
|
MarkAn | Word VBA | 2 | 08-15-2014 06:50 AM |
Number format in Textbox on userform
|
officeclerk | Excel Programming | 2 | 04-17-2012 01:23 AM |
| Spell Check | WorkerB | Word | 2 | 11-21-2009 07:22 AM |