ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Esc Botton while filling in userform (https://www.excelbanter.com/excel-programming/313864-using-esc-botton-while-filling-userform.html)

helmekki[_37_]

Using Esc Botton while filling in userform
 

Hi

if i am filling in a userform and suddenlly decide to Esc,
is there a code to do this?

is there a code to move the cursor from a textbox to the Load botto
without having to pass all the textboxes ?

yours


--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=27010


keepITcool

Using Esc Botton while filling in userform
 
set the Cancel property of a Button to true
and that button's code will be executed on the press of esc.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


helmekki wrote:


Hi

if i am filling in a userform and suddenlly decide to Esc,
is there a code to do this?

is there a code to move the cursor from a textbox to the Load bottom
without having to pass all the textboxes ?

yours
h





All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com