Thank you

That is just what I was hoping for.

-Minitman

On Fri, 22 Oct 2004 10:09:06 -0700, "Datasort"
wrote:

Try the event

Private Sub TBox_NAME_Exit(ByVal Cancel As MSForms.ReturnBoolean)

where TBox_NAME is the name of your text box

"Minitman" wrote:

Greetings,

I need to have a format command to wait until I have finished typing
in a TextBox and when I exit the TextBox for the format to run then.
I have checked the help files for what events are available and could
not find one that would work.

Any one have any suggestions?

TIA

-Minitman