Automatically close a form once I hit enter?

afs24

Board Regular
Joined
Sep 26, 2002
Messages
237
I have a field labeled carrier. Once I enter a new carrier in the carrier field or text box and then hit enter I want the form to close. Is there something I can write in the properties-events section to make this happen? Is there a way??? thanks!!! Rough example of what the form looks like:


Carrier: "this is where I would write in the new name and after I hit enter the form should close"


Add Record Delte Record Close Form
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Re: Automatically close a form once I hit enter in a text b?

I'll try to explain this a little better.

My label name is carrier.
My text box is where I'm entering in new names.
Once I enter in a new name I want to hit enter and then I want the form to close.

Is there anyway to do this? I was thiking to add code into the on enter procedure in the events sections?

Please advise!!!!! thanks you!!!!
 
Upvote 0

Forum statistics

Threads
1,221,710
Messages
6,161,445
Members
451,706
Latest member
SMB1982

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top