Trouble with a command button.

[JohnPoole]

I have a command button which has both a single click and a double click routine. Is there anyway to make the single click routine run only once without locking or disabling it after it is clicked, so that the double click routine can still be called, but the single click routine can no longer be used?
Any help greatly appreciated........

 

[Norie]

John

I don't quite follow. Could you give more details?

What do the seperate events do?

Where is the command button located?

 

[JohnPoole]

Hi, the single click event simply loads a picture to the commandbutton and minuses 1 to a counter, the double click event minuses 1 to the counter and disables the button until the form is reset. My problem arises in that I want the single click event to be recorded only once, if a user clicks single clicks more than once the counter is reduced by the number of the single clicks. I therfore wish to disable the single click event after it has been used once, leaving only the double click event available. Hope this makes sense. thanks for your help!

 

[Norie]

John

Still not quite getting it, perhaps a Saturday night thing.

Where is your code/button located?

Is it on a userform?

If it is I suppose you could use a variable to indicate whether or not the single click event has been run.

When the userform opens it would be False, then it would be set True on the first run of the event.

The code for the event could check the variable to see if the event has been run previously, and act accordingingly ie. stop execeution of the code.

 

[JohnPoole]

Hi Norri, thanks for your reply. yes the button is on a userform. i'll try and use your method and see how far i get . I'll leave some feedback once I've given it ago. many thanks.

 

[JohnPoole]

Hi Norri,
Many thanks for the advice, got the button working perfectly using a variable to detect if the button had already been clicked as you suggested. Many thanks!