You need to change the LinkCell property of the Option button.
On excel spreadsheet Menu - View - toolbar - Control Toolbar. Enter design
mode (triangle). Then press conhtrol button and select properties on the
toolbar. Chenge LinkCell to any cell.
Then double click option button to open a VBA macro. Add code below. Each
button will have its own macro.
Private Sub OptionButton1_Click()
linkcell = OptionButton1.LinkedCell
Range(linkcell).Select
End Sub
> How to Set Focus to the row - Option Button Click
>
[quoted text clipped - 18 lines]
> does anyone have any ideas on how to change the focus when an Option Button
> is clicked?
Lisab - 26 Sep 2007 21:50 GMT
I used the Option button from the Forms toolbox
When I look at the Command Button from the Control Toolbar I do not see the
LinkCell Property in the property window. However, there is a
TakeFocusOnClick property.
I am going to change my option butttons to command buttons and see if that
works.
> You need to change the LinkCell property of the Option button.
>
[quoted text clipped - 32 lines]
> > does anyone have any ideas on how to change the focus when an Option Button
> > is clicked?