Disabling buttons upon execution
Disabling buttons upon execution
(OP)
I have a form with 5 buttons. The user must click those buttons in order - for example, they will mess things up if they click button 2 before button 1, or if they click button 1 twice. I'd like to disable the button upon successful execution of the macro called when the button is clicked.
I tried disabling the button in the ONCLICK macro, but it appears I can't do that. I don't think that I should do that anyway, because each time my application is restarted, the first button is enabled and the others disabled (as I set them in the form properties)- what I really want is a variable or something to hold the users place in the cycle of buttons.
I tried disabling the button in the ONCLICK macro, but it appears I can't do that. I don't think that I should do that anyway, because each time my application is restarted, the first button is enabled and the others disabled (as I set them in the form properties)- what I really want is a variable or something to hold the users place in the cycle of buttons.
RE: Disabling buttons upon execution
Does that sound like something you would want to do?
Kathryn
RE: Disabling buttons upon execution
RE: Disabling buttons upon execution
RE: Disabling buttons upon execution
Can you tell me specifically how to use a static variable to keep their place? I'm new to VBA.
Caroline
RE: Disabling buttons upon execution
Since you are going with the five button method, you will have more than one procedure, so I don't think that this will work for you.
Check out the help topic "Static Statement" for a bit more info.
Kathryn