Spell Check a Single Word with VBA (Excel 2000 SR-1)

Topic

New Reply

Hello,

I would like to spellcheck a single word entered on a userform. I can use the application.checkspelling method, but it only returns true or false and I would like to display a Excel’s normal spell check dialog box.

Is there any way to check spelling with VBA and not have to copy the word to be checked to a worksheet?

Thanks,

Reply | Quote

Replies

I do NOT think so.

The CheckSpelling Method is only valid for a
Chart
Range
Worksheet
Application

If you use Application, you must give it a word and it only returns just true/false.

If you place it in a cell (a cell object is a range object), you can pull up the dialog box. You could add a worksheet, add the word to the worksheet, then spellcheck the worksheet to get the dialog box. Afterwards you can delete the new worksheet.

Steve

Reply | Quote

I do NOT think so.

The CheckSpelling Method is only valid for a
Chart
Range
Worksheet
Application

If you use Application, you must give it a word and it only returns just true/false.

If you place it in a cell (a cell object is a range object), you can pull up the dialog box. You could add a worksheet, add the word to the worksheet, then spellcheck the worksheet to get the dialog box. Afterwards you can delete the new worksheet.

Steve

Reply | Quote