Wait for action

[Johan]

Hallo!

I want to make a macro that show a userform with a button.
If the user have not clicked the button within 15 sec I want the code to
continue.
If the user click the button the code will end.

Thanks for any help!

Johan

 

[Johan]

Thanks for your help joel, however the code goes to Error and gives the
following message:

Run-time error '1004':
Metode 'OnTime' of Object'_Application' failed

Any help on that?

Thanks
Johan

joel skrev: