![]() |
|
|
|
#1
|
||||
|
||||
|
Try it with a couple of little changes 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, oRng As Range
With oTxtBox
If Not .value = "" And Not .value = "<WhatEver>" Then
Set oDoc2 = Documents.Add
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.Saved = True
oDoc2.Close SaveChanges:=wdDoNotSaveChanges
Set oDoc2 = Nothing
End If
End With
End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
|
|
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 |