Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use ENTER in a TextBox in Excel 2007
Hi
I have created a Userform containing some OptionButtons, a TextBox, a OK and a Cancel button. I have created a Click behavior for the OK button where I check for which OptionButtons a user have chosen or if any text is entered in the TextBox. I would like to add a behavior for the TextBox where I can press ENTER and it then runs the same macro as pressing the actual OK button. At the moment when pressing ENTER in the TextBox it moves the focus to the next object in the tab order. Any ideas? /Lasse |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use ENTER in a TextBox in Excel 2007
Hi,
Use the textbox exit event macro. Regards. Daniel Hi I have created a Userform containing some OptionButtons, a TextBox, a OK and a Cancel button. I have created a Click behavior for the OK button where I check for which OptionButtons a user have chosen or if any text is entered in the TextBox. I would like to add a behavior for the TextBox where I can press ENTER and it then runs the same macro as pressing the actual OK button. At the moment when pressing ENTER in the TextBox it moves the focus to the next object in the tab order. Any ideas? /Lasse |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use ENTER in a TextBox in Excel 2007
Lasse
Set the OK button's Default property to True and it clicks on Enter. (Likewise, set Cancel buttons Cancel property to true and it clicks on Esc.) HTH. Best wishes Harald "Lasse" wrote in message ... Hi I have created a Userform containing some OptionButtons, a TextBox, a OK and a Cancel button. I have created a Click behavior for the OK button where I check for which OptionButtons a user have chosen or if any text is entered in the TextBox. I would like to add a behavior for the TextBox where I can press ENTER and it then runs the same macro as pressing the actual OK button. At the moment when pressing ENTER in the TextBox it moves the focus to the next object in the tab order. Any ideas? /Lasse |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Textbox Formatting | Excel Programming | |||
Office 2007 - Using "Enter" in textbox | Excel Discussion (Misc queries) | |||
Want Enter to put CR in Textbox (not just CTRL-Enter) | Excel Programming | |||
Can you Click the "Enter" key to go to the next line in a Textbox without Exiting the Textbox ? | Excel Programming | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming |