Changing how "Enter" works on a Userform
All,
Random one for you.
I have a user form with a set of boxes and then some buttons. When a user presses "Enter" they automatically press a button, no matter which box they are in. How do I change "Enter" to working like "tab"
Sorry it is really hard to explain but I hope this make sense, and is an easy fix.
R
Hello rpjwhite,
And what shall we do if we need to really "Enter" something somewhere, and all it does, is "Tab" to the next input field?
Please atach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Thank you.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
I reckon one of your buttons has its default property set to true. make sure they're all false
Josie
if at first you don't succeed try doing it the way your wife told you to
JosephP - You were correct but it doesn't fix the ?Tabstop? issue.
Winon - Deep thought. I will try JosephP fix and see how my users get on.
Thanks both
R
enter should work like tab by default. what does it do now that it doesn't press the button?
Interestingly it varies:
So in a combo box it does nothing even in an option is selected.
In a single line textbox it goes to the next text box
On a mulitline textbox - next line
On an Optionbutton... Nothing - I can live with that
But is not not pressing yes on one of the buttons which is good. Winon is correct is some case I want it to work like tab in other I want it to work like enter..
R
is your combo box style set to 2? a multiline text box with its enterkeybehavior set to true will use the enter key for a new line. if you don't want that, set it to false. might could confuse the user though ;-)
Last edited by JosephP; 02-09-2017 at 09:41 AM.
Yes it. Will that stop it playing?
yeah if it's set to 2 the enter key won't tab
Ah Well.
To be fair you have fixed the problem. A colleague did suggest I write some code so every time they pressed "enter" a message box flashed up with "Press Tab!!"
Thanks again
R
if you're gonna do that you could just tab for them!
thanks for the rep-btw josie is a girl's name ;-)
@ JosephP,
Great solution brethren!
Rep added.
Regards.
@JosephP
Apologise Josie, I missed you initial signature...
#embarrassed face#
nae bother (is that right?)
it ain't your fault the forum only shows a signature once!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks