PDA

View Full Version : option button macro



arnab0711
01-31-2011, 10:57 PM
Hi,
I have this sheet with Option buttons on column A,I want at the click(or enable)of each option button the contents of cell F8 - F14 will get copied to cell I5
for example if button on cell A8 is selected contents of F8 will get copied to cell I5 again if
button on cell A9 is selected contents of F9 will get copied to cell I5

mancubus
02-01-2011, 01:51 AM
try stg like this:
(objects' worksheet's code module. must write code for each object.)


Private Sub OptionButton1_Click()
If Sheets("Chart").OptionButton1.Value Then
Range("I5").Value = Range("F8").Value
End If
End Sub