Referencing an option button click between worksheets

[JustineM]

Hi,

I've added some VBA code to update a cell value when an option button is clicked. The option button is part of a group, all events occur on the same worksheet. My code below:

Private Sub OptionButton1_Click()
Range("A2") = "1"
End Sub

I've repeated this code for all 5 option buttons and it works OK.

On another worksheet, I'd like a cell value to be updated with the contents of a cell, when the option button click is TRUE.

E.g.
Sheet 1
Click Option Button 2
Cell ref A2 changes to show rating 2
On worksheet 2
Cell ref changes to show contents of Sheet 1, cell ref C1

Do I add the event on the sheet where the option button is, if so how? Or, add VBA code on the sheet where I want the text string to be displayed and reference the button click?

Many thanks
JM

 

[NdNoviceHlp]

Hi JM. Add the option button code to the sheet where the option button is located. Something like this...

Private Sub OptionButton2_Click()
Sheets("Sheet1").Range("A2") = "2"
Sheets("Sheet2").Range("SomeCell") = Sheets("Sheet1").Range("C1")
End Sub

HTH. Dave

 

[JustineM]

Dave,

This worked as I needed. I was also able to include other actions from the button click.
I was so close in my previous attempts.

Thank you
Jm,

 

[NdNoviceHlp]

You are welcome. Thanks for posting your outcome. Dave