In the Exit event, set cancel = true

In the same event,

Textbox1.Text = ""

--
Regards,
Tom Ogilvy

"abxy" wrote in message
...

Hi,

I'm designing a userform for data entry.

I'd like to have the userform set up that I can put text in a textbox
and press enter, then it does what it's supposed to do and clears the
textbox so that I can type new text in. I've seen other vb programs
that do this.

With the way things are now, when I press enter it does everything it's
supposed to do, but the focus always moves to the next control.

Is there anyway that I can stop the focus from moving to the next
control when I press enter?

Thanks a lot for the help. I appreciate it. :)


--
abxy
------------------------------------------------------------------------
abxy's Profile:
http://www.excelforum.com/member.php...fo&userid=4730
View this thread: http://www.excelforum.com/showthread...hreadid=400574