Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Capture Enter in textbox

I would like to make it so that when a user presses enter in a single line
textbox, the textbox value gets written into some other place and the focus
ends up back in the textbox. I could do all that if I could capture the
Enter, but I don't see a way to do that. Any ideas?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Capture Enter in textbox

Look at the keydown or keyup events in a textbox from the control toolbox
toolbar.

You don't say where the textbox is, so make sure you read the help on these
events. (such as cautions for a userform with a commandbutton set to true
for the default property).

--
Regards,
Tom Ogilvy




"FClifton" wrote:

I would like to make it so that when a user presses enter in a single line
textbox, the textbox value gets written into some other place and the focus
ends up back in the textbox. I could do all that if I could capture the
Enter, but I don't see a way to do that. Any ideas?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you Click the "Enter" key to go to the next line in a Textbox without Exiting the Textbox ? Corey Excel Programming 1 February 22nd 07 05:09 AM
Capture the range a user selects and put in textbox. Drew[_9_] Excel Programming 2 March 31st 06 04:02 PM
Capture ENTER Ed Excel Programming 3 October 7th 05 10:07 PM
how to capture enter key inside a cell helpwithXL Excel Programming 3 April 1st 05 03:54 PM
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys Minitman[_4_] Excel Programming 0 February 22nd 05 08:50 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"