Excel VBA - Form Textboxes - spellchecking 1

[p20nty]

Hi,
Ive programmed a Form in Excel with (amoungst combo boxes etc) which 'data links' to a specific cell containing in the Excel spreadsheet ('Field' in Access). The form acts as a User Interface and works well - you can navigate between each row (record) and add/delete/amend data and data validation can be carried out programatically. However I want to spell-check the text entered into the text box by the user, using a command button on the form. Is this possible in Excel. If so how do you do it?
Please help. Best regards.
Mike

 

[jcfoley]

Use VBA's object browser and look for a "range" object. This object has a method called "checkspelling". You will most likely have to copy the textbox text to a cell, check the spelling, and then copy this back to the textbox.

 

[p20nty]

Hi jcfoley,
Many thanks for your helpful advice/solution. Implemented OK.
Mike