SpellingOptions.UserDict Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Instructs Microsoft Excel to create a custom dictionary to which new words can be added to, when performing spelling checks on a worksheet. Read/write String.

expression .UserDict

expression A variable that represents a SpellingOptions object.

This example instructs Microsoft Excel to create 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
Show: