Option Buttons as Radio Buttons

[brendalpzm]

I'm using activeX controls, and I'm wondering if there's a way to use command buttons as option (radio) buttons and link the result to a cell,

For example if I link thebuttons to the A1 cell, when I click on button 1 the result shows up in A1, and if I click on button 2 the result changes in A1

Idk if I explained myself :S

 

[DanteAmor]

Thanks for posting on the forum.

I don't understand your explanation at all.
In order for me to better understand the problem, I would like to ask a few questions:
- The 2 combos point to the same cell A1?
- What value do you want to put in cell A1 when you press button1?
- What value do you want to put in cell A1 when you press button2?

I include an example, maybe I can hit what you want.

Private Sub CommandButton1_Click()
  Range("A1").Value = "bt1"
End Sub

Private Sub CommandButton2_Click()
  Range("A1").Value = "bt2"
End Sub

Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --

 

[brendalpzm]

Thanks for posting on the forum.

I don't understand your explanation at all.
In order for me to better understand the problem, I would like to ask a few questions:
- The 2 combos point to the same cell A1?
- What value do you want to put in cell A1 when you press button1?
- What value do you want to put in cell A1 when you press button2?

I include an example, maybe I can hit what you want.

Private Sub CommandButton1_Click()
  Range("A1").Value = "bt1"
End Sub

Private Sub CommandButton2_Click()
  Range("A1").Value = "bt2"
End Sub

Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --

actualy your solution worked pretty well thanks~!