Double Clicking a Command Button

Good Day Everyone!

Can someone tell me how to have a userform show IF a command button is clicked twice?

I have a command button that I wish only to be clicked once. If the user happens to click this button twice, the data on the sheet will become incorrect. Is it possible so that if the user clicks the button more than once a popup will display telling them that they've already clicked the button?

Many thanks!
Jay

Jay

Could you add a cell that is initialised at some point to TRUE (don't know what criteria you have to allow the button to be actioned) and only allow the button to work if the field is TRUE? Part of the processing would turn it to false.

Another possibility would be to turn the button invisible once it has been pressed once, so it could not be pressed a second time. Again, there would have to be some sort of initialization to make it available when require.

HTH

rylo