View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
abxy[_74_] abxy[_74_] is offline
external usenet poster
 
Posts: 1
Default Keeping The Focus From Changing. How?


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 textbo
and press enter, then it does what it's supposed to do and clears th
textbox so that I can type new text in. I've seen other vb program
that do this.

With the way things are now, when I press enter it does everything it'
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 nex
control when I press enter?

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

--
abx
-----------------------------------------------------------------------
abxy's Profile: http://www.excelforum.com/member.php...nfo&userid=473
View this thread: http://www.excelforum.com/showthread.php?threadid=40057