View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jamescox[_62_] jamescox[_62_] is offline
external usenet poster
 
Posts: 1
Default Spell Check in Text Boxes


The code goes into a code module, not a sheet's code or the
ThisWorkbook module.

If that didn't make a lot of sense, you need to get into Visual Basic
from the Developer tab on the ribbon menu. (If you don't have a
Devloper tab, click on the Office orb - that round button at the top
left of the Excel window, select Excel Options and then on the 'Popular
window, check the third box down Show developer tab in the ribbon).

On the left hand side of the VB editor window, there should be Project
- VBA Project pane and it should have listed your workbook as a VBA
project. Right click on the VBA project that has your workbook name in
parentheses and from the pop up menu select Insert and then Module.
This should open up a code window in the editor - and that's where you
paste the code; it will be a macro.

To run the macro, go to the View tab on the ribbon, click on the Macro
button and from the window that pops up, select the SpellCheckTextboxes
item and click on Run.

That should get you there!
To run it, select the worksheet you want to spell-check


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=120599