Hello,

I created two radio buttons on a spreadsheet where a user can select
one button for Yes and the other for No. When I right click these
buttons, I notice the names (shown on the left hand side of the
formula bar) a

Option Button 3 (for No)
Option Button 4 (for Yes)


I'd like to create a macro that automatically selects the Yes or No
button depending on a cell value in another tab. If the cell value is
1, the macro should select Yes. If the value is 0 the macro should
select No.

How do I go about doing this?

Can someone help me out with some code?

Thanks!

Hi,

maybe something along these lines

Sub merge()
If Not IsEmpty(Sheets("Sheet2").Range("A1").Value) Then
Select Case Sheets("Sheet2").Range("A1").Value
Case Is = 1
Sheets("Sheet1").OptionButton4 = True
Case Is = 0
Sheets("Sheet1").OptionButton3 = True
End Select
End If
End Sub

Mike

"ac1179" wrote:

Hello,

I created two radio buttons on a spreadsheet where a user can select
one button for Yes and the other for No. When I right click these
buttons, I notice the names (shown on the left hand side of the
formula bar) a

Option Button 3 (for No)
Option Button 4 (for Yes)


I'd like to create a macro that automatically selects the Yes or No
button depending on a cell value in another tab. If the cell value is
1, the macro should select Yes. If the value is 0 the macro should
select No.

How do I go about doing this?

Can someone help me out with some code?

Thanks!

On Oct 17, 4:39*pm, Mike H wrote:
Hi,

maybe something along these lines

Sub merge()
If Not IsEmpty(Sheets("Sheet2").Range("A1").Value) Then
Select Case Sheets("Sheet2").Range("A1").Value
* * Case Is = 1
* * * * Sheets("Sheet1").OptionButton4 = True
* * Case Is = 0
* * * * Sheets("Sheet1").OptionButton3 = True
End Select
End If
End Sub

Mike



"ac1179" wrote:
Hello,

I created two radio buttons on a spreadsheet where a user can select
one button for Yes and the other for No. When I right click these
buttons, I notice the names (shown on the left hand side of the
formula bar) a

Option Button 3 (for No)
Option Button 4 (for Yes)

I'd like to create a macro that automatically selects the Yes or No
button depending on a cell value in another tab. *If the cell value is
1, the macro should select Yes. *If the value is 0 the macro should
select No.

How do I go about doing this?

Can someone help me out with some code?

Thanks!- Hide quoted text -

- Show quoted text -

Hey Mike,

I gave that a try, but the following error came up:

Run-time error 438
Object doesn't support this property or method

When I click debug, the text "Sheets("Sheet1").OptionButton4 = True"
was highlighted.

Any thoughts? Thanks again!