I am in need of preventing a CommandButton from recognizing more than one click ... then after a 3 second pause be ready to accept another click. BUT not recognize or accept any clicks during that 3 second pause.



Trying to prevent the user from clicking multiple times and increasing the registered counts resulting from those extra clicks. This is used in a small VOTING app.

The button is pasted onto a worksheet.

Thanks.

Attached Files

ELECTION 1.1.xlsm (19.6 KB, 2 views)

Try the attached. When any of the 4 buttons is clicked, all of the buttons won't respond to a click for three seconds.

Attached Files

msofficeforums51199ELECTION 1.1.xlsm (24.6 KB, 2 views)

p45cal :

Thanks so much for the solution. Without your assistance I would be working on it forever.

Here's a modified version (code edited by ByteMarks and sound by me).

Attached Files

Election Vote Tracker w Sound.xlsm (186.4 KB, 0 views)