more user form questions - option button events

[mortgageman]

What is the difference between

Private Sub OptionButton7_Click()

and

Private Sub OptionButton7_Change()

Edit - other than the fact that I put the first in red

 

[acw]

Hi

Code associated with the first one will run when it is clicked. Code from the second will only run when it is change. So if you click the optionbutton, but don't change it, then nothing will happen.


Tony

 

[mortgageman]

I'm not fully sure I understand. No - I am fully sure that I don't understand. I thought an option button can only have two states - clicked or not-clicked. If you click it, then haven't you CHANGED it from being not-clicked?

Gene, "The Mortgage Man", Klein

 

[Nimrod]

Private Sub OptionButton1_Change()
MsgBox "Change"
End Sub

Private Sub OptionButton1_Click()
MsgBox "click"
End Sub

Put 2 buttons on a form and insert the preceeding code .... I think you will see the difference :wink: .

When optionButton1 has been selected you will find that both events fire. However when you now click on another optionbutton only the "Change" event will be fired. This is because the value of the button1 has changed even though you clicked on optionbutton2. :wink:

In other words a value of an option button can be changed , not only by clicking on it , but also by clicking on another button. Since this action will transfer the true value to the newly clicked option button.

 

[acw]

Hi

Got that a bit wrong. If you click the button, it will change. But you can change the button without clicking it. So you can get 2 things the click action and the change action. However, if you have 2 buttons, and the first one is selected, then you click the second one, then the first will have the change event, but not the click event.

Go to a spreadsheet and create 2 option buttons. Put in the following code for the option button 1

Private Sub OptionButton1_Change()
MsgBox "button changed"
End Sub

Private Sub OptionButton1_Click()
MsgBox "button Clicked"
End Sub

When you select option button 1, then you will get 2 messages. However, when you select the second button, you will only get 1 message.


HTH

Tony

 

[mortgageman]

In other words a value of an option button can be changed , not only by clicking on it , but also by clicking on another button. Since this action will transfer the true value to the newly clicked option button.

OK - so does this mean if I only use click and never change, then I have restricted the user to picking one and only one button?

Gene, "The Mortgage Man", Klein

 

[acw]

Gene

Depends on what you have setup. If you only have one button, then the user doesn't have much choice. If you have multiple buttons, and only code for the click event, it will only action when that button is selected.


Tony