Selecting Radio Buttons by Using Macros
 

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!

Selecting Radio Buttons by Using Macros
 

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!

Selecting Radio Buttons by Using Macros
 

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!