Hey Tom.

I must apologize. I did not understand that "Exit" was the name of
the Exit event until I saw the code snippet. My only excuse is my
inexperience with VBA and writing code.

I did not mean to "Kick" you once or again.

Please accept my apology.

I find the knowledge and assistance you dispense so unselfishly to be
of great value. Please, don't let my ignorant babblings discourage
you in the pursuit of educating the unexperienced and uneducated
wannabe Excel programmers out here to comprehend the deepest mysteries
of Excel. <G

-Minitman



On Fri, 22 Oct 2004 15:16:24 -0400, "Tom Ogilvy"
wrote:

If the textbox is in a userform, then use the Exit event.

Read my suggestion. The first suggestion I made was the exit event (which
only works for a userform). This is the same suggestion posted after me by
Mr. Datasort. without such qualification or explanation and which you found
so helpful. I then offered an alternative approach again, stating clearly
that this was if your textbox was not on a userform.

Check out the other reply, it seems to be a bit more simplified.
Kick me again <LOL