Hi everyone,
Is there a way that I can do a spell check in a UserForm, before the information is sent to the worksheet. I know I can add code to do a spell check after the information is added to the worksheet, but in my case, some of the text will be sent to two different worksheets. Therefore if the user made a spelling mistake, the spell check needs to run on both sheet and the user will have to rectify the same mistake twice.
Perhaps some code to run a spell check before the CommandButton send the information to the relevant sheets.
Is there a way that I can do a spell check in a UserForm, before the information is sent to the worksheet. I know I can add code to do a spell check after the information is added to the worksheet, but in my case, some of the text will be sent to two different worksheets. Therefore if the user made a spelling mistake, the spell check needs to run on both sheet and the user will have to rectify the same mistake twice.
Perhaps some code to run a spell check before the CommandButton send the information to the relevant sheets.
