Hello GrahamD,

Assume you have 4 options button(radio buttons) named a to d.
To make a radio button selected, you need to specity the Worksheet name and
the control name like this.
Here is acode for CommandButtons.

Private Sub CommandButton1_Click()
Sheet1.a.Value = True
End Sub

Private Sub CommandButton2_Click()
Sheet2.b.Value = True
End Sub


--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

"GrahamD" wrote in message
...

Hi please bear with me on this as I'm new at this!!
I'm trying to work out how to use Radio Buttons with Command Buttons?
I have 4 buttons (A,B,C,D, each for a different worksheet ) and 9
Command Buttons (1 to 9 with Names),what code do I need if I click on a
button (Name) to go to the selected radio button??
Any help appreciated.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements