Hi Frds,

I have a problem in using Offset .

Code Objective:
I have 4 option buttons, i need to display the order in which the button are clicked. say if OptionButton1 is clicked, then in cell N1, it has to display "Button1" and then if Option Button 2 is clicked , in Cell N2 , "Button2" to be displayed

Here is my code .. when i run it .. It is throwing error 6 at "x= x+1"

Private Sub OptionButton1_Click()
Dim x As Integer
x = 2
Do While Cells(x, 13) <> " "
x = x + 1
Loop
Cells(x, 13).Value = " This is button 1"
End Sub

Same code for all the other 3 Optionbuttons ...

Please help ..!!

Thanks in Advance !

Regards,
Sri