Posted to microsoft.public.excel.programming

Jason Paris[_2_] Jason Paris[_2_] is offline

external usenet poster

Posts: 8

Linking the ENTER key to a Button on a Form?

Hi folks,

I'm creating a User Form in Excel. It includes a Text Box and a
number of buttons.

When the user types into the Text Box and (instinctively) presses
ENTER, is there a way to simulate the clicking of a button? In other
words, can ENTER - when pressed from the Text Box - be used to trigger
the code behind a button?

Many thanks,

Jason Paris

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Is there a way to make the enter button work as regular enter	Ricter	Excel Discussion (Misc queries)	1	November 17th 09 02:50 AM
Create a form in excel so I can enter data using DataForm	Lynn	Excel Discussion (Misc queries)	2	February 14th 07 06:35 PM
Command Button vs Form Button	Bri[_3_]	Excel Programming	2	February 3rd 06 08:18 AM
enter button in vb	brian parry	Excel Programming	0	April 23rd 04 08:07 PM
Command Button vs Form Button	T K	Excel Programming	4	August 26th 03 07:26 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us