I have some 4 questions in excel which has radio buttons in it.
I am writing a vba code into it but its giving an error
i have this requirement
if option button 1 is clicked in Q1 i want it to range to cell which has question Q3
if option button 2 is clicked in Q1 i want it to range to cell which has question Q4
I am checking this code in Q2 option button click

Sub optionbutton2_click()
if optionbutton1.enabled=true then range("b3")
else if optionbutton2.enabled=true then range("b4")
End sub.

its giving me an error saying object is required
Can someone please help me on this.

Salma, try this;

sub optionbutton1_click()
cells(3,"B").select
end sub

sub optionbutton2_click()
cells(4,"B").select
end sub