title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
SpellingOptions.UserDict property (Excel) |
vbaxl10.chm717074 |
|
|
8816b44e-98e5-8829-cb6e-af4ac4040838 |
05/16/2019 |
medium |
Instructs Microsoft Excel to create a custom dictionary to which new words can be added when performing spelling checks on a worksheet. Read/write String.
expression.UserDict
expression A variable that represents a SpellingOptions object.
This example instructs Excel to create a custom dictionary called Custom1.dic in the spelling options feature and notifies the user.
Sub SpecialWord()
Application.SpellingOptions.UserDict = "Custom1.dic"
MsgBox "The custom dictionary is currently set to: " _
& Application.SpellingOptions.UserDict
End Sub
[!includeSupport and feedback]