| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel return on keyboard
Hi Alvin,
There isn't a built-in event to do that in VBA. You can create custom events with VBA. See Event in VBA help. You would need to raise your event when your conditions are met, or not met. Then test for the event in the begining of your button code to exit the sub if the event was (is) raised. -- John johnf202 at hotmail dot com "Alvin Hansen" wrote in message ... : hi : I can in a asp/html or whatever : cancel the effect on the return button : on the keybord : So my command button dont work : with this : i use : function cancelEvent() { : window.event.returnValue=false; : window.event.cancelBubble=true; : } : CAn't i do the same in a userform?? : : resgards alvin : |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cancel return on keyboard
Thank you for your help
Regards alvin "jaf" skrev: Hi Alvin, There isn't a built-in event to do that in VBA. You can create custom events with VBA. See Event in VBA help. You would need to raise your event when your conditions are met, or not met. Then test for the event in the begining of your button code to exit the sub if the event was (is) raised. -- John johnf202 at hotmail dot com "Alvin Hansen" wrote in message ... : hi : I can in a asp/html or whatever : cancel the effect on the return button : on the keybord : So my command button dont work : with this : i use : function cancelEvent() { : window.event.returnValue=false; : window.event.cancelBubble=true; : } : CAn't i do the same in a userform?? : : resgards alvin : |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find keyboard short-cut to type symbols on keyboard | Excel Discussion (Misc queries) | |||
| Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work | Setting up and Configuration of Excel | |||
| Return Button on the Keyboard | Excel Worksheet Functions | |||
| keyboard shortcut to return to previous cell after "find" or "got. | New Users to Excel | |||
| Return value for Cancel? | Excel Programming | |||
Linear Mode
