Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a working userform that I would like to make more user-
friendly. Four option buttons, a text box, OK and Cancel buttons. I want the user to be able to press enter from the option button that has the focus and go straight to the textbox without tabbing through all the other option buttons. Ideally, pressing enter would automatically "click" that option button but I'm ok with using spacebar. Then, pressing enter from textbox1 still needs to activate the OK button (as it currently does). I thought it would look (partially) like this: private sub optionbutton1_enter( ) textbox1.default = true end sub private sub textbox1_enter( ) commandbutton1.default = true 'commandbutton 1 is the OK end sub the error message I get when I run the form reads "Could not set the default property, member not found." in regards to the option button_enter, even if I comment out the textbox1_enter section. What should I be trying? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
KEEP THE CELL MARKER FROM MOVING DOWN, AFTER ENTER | Excel Discussion (Misc queries) | |||
Moving between cells when enter is pressed | Excel Discussion (Misc queries) | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
moving to next cell using "Enter" | Excel Discussion (Misc queries) | |||
moving the cell pointer after hitting enter | Excel Programming |