VBA Insert Row using ActiveX Radio Buttons

[tinydoomfists]

Hello, I'm new to VBA.
I'd want to insert a row under in two columns only using "yes"/"no" option buttons (as shown).
When "yes" is selected a new row will be created.
If "no" is selected then the created row will be deleted.

Hoping for something simple enough that can be modified & used throughout the worksheet.

Thanks!

 

[MARK858]

You can't insert a row under 2 columns a row is an entire row.
Do you mean insert 2 cells? if yes how are you defining the cells to insert under i.e. selecting both cells, selecting 1 cell or something else?

 

[tinydoomfists]

You can't insert a row under 2 columns a row is an entire row.
Do you mean insert 2 cells? if yes how are you defining the cells to insert under i.e. selecting both cells, selecting 1 cell or something else?

Cells! I meant, cells. & I'd be selecting both cells

 

[MARK858]

Testing it I am not sure about it as you lose the selection when you click the Option button.

 

[tinydoomfists]

That's..... interesting.
Whatever you can send will be tremendously helpful. I can play around with it & see if I can find a way to make it work

 

[tinydoomfists]

Testing it I am not sure about it as you lose the selection when you click the Option button.

Any luck?

 

[MARK858]

All that you need is

If Range(yourcellrange) = True Then Selection.Offset(1).Insert

in one Option buttons code module and

If Range(yourcellrange) = False Then Selection.Offset(1).Delete Shift:=xlUp

in the other

 

[tinydoomfists]

All that you need is

If Range(yourcellrange) = True Then Selection.Offset(1).Insert

in one Option buttons code module and

If Range(yourcellrange) = False Then Selection.Offset(1).Delete Shift:=xlUp

in the other

Amazing! Thank you!