I am running a macro that places an option button in my worksheet. However, I cannot place it in the location I want. When running the macro the button is placed wherever the cursor is.
I tried the running the macro using:
Am I missing something?Sub ShowPerBox() Dim rng As Range Set rng = ActiveSheet.Range("L18") With ActiveSheet.OptionButtons.Add(Selection.Left, Selection.Top, Selection.Width, Selection.Height) .Name = "OptionButton1" .Caption = "CONFIRM" End With End Sub