Forum Discussion
command button- spell check
how do you create a spell check command button in excel?
ExcelExciting thanks for your response, this is a report for others that goes to owners, it would be easier for them if the button was on the form to help them not to forget to spell check 🙂
hi graceo
You can use the below code and paste it to the module and then assign it to button.
Sub SpellCheck()
Cells.CheckSpelling IgnoreUppercase:=False, AlwaysSuggest:=True
End SubI would suggest you also to paste this code before workbook is close, it would great incase if the users forget to do the spellcheck.
Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget to mark it as the Official/Best Answer & like it to help the other members find it more.