Automatic Spell Check??

**pcm034** · 03-03-2013, 07:49 AM

I want to run a spell check on the contents entered by a user into a field on an active Form. This can be either automatic as user types or manually activated via a button on the Form itself. Can this be done and if so, what code would allow this to take place. Would this just be easier to create a button_click macro for each page? I am fairly new to VBA and still working on understanding each process. Thank you in advance for the direction.

**event21** · 03-03-2013, 08:30 AM

Hi -

Please Login or Register  to view this content.

from http://www.ozgrid.com/forum/showthread.php?t=23307

event

**pcm034** · 03-03-2013, 09:49 AM

I get a Compile error- (User defined type not defined) on the this text string- Ideas?
I am new enough to VBA that I do not understand even the definition of this statement completely.

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

**event21** · 03-03-2013, 06:59 PM

Hi -

Please Login or Register  to view this content.

TextBox1 in bold should be the name of your textbox control

event

**jaslake** · 03-03-2013, 07:57 PM

Hi pcm034

This error

User defined type not defined

typically indicates a missing Reference. If that's the case perhaps event21 can identify that Reference for you and demonstrate to you how to create the Reference.