Grouped Radio Buttons on mixed locations on the worksheet

axelg

New Member
Joined
Jan 21, 2016
Messages
42
Office Version
  1. 365
Platform
  1. Windows
On my Worksheet I wan't to work with groups of Radio buttons.
So I created groups for this, in each group there are 2 buttons.
Then I point these buttons to another workbook for the results.
If I then test, all works fine.

But I need these on different locations on my worksheet so i Slide them out of the group box to the desired location.
If I then run my tests, all still works fine.
But if I then save and reopen, all the groups seem to have gone ?

I need a result for my radio buttons (May be other function if there is a better way) mixed like below.
This is the order they need to be in. This is different locations on the worksheet


A1
B1

A2
B2

C1
D1

C2
D2

Or should the group box always stay around the grouped radio buttons.

Many thanks
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Is this on a worksheet? If so , the ActiveX buttons can be anywhere, there group control is the sheet they are on.

1676453020911.png
 
Upvote 0
Solution
It should like this.

1676454747903.png

But I would like the final result to look like this
1676454815517.png

(Preferably with the group boxes invisible... But for that I already found a VBA command
activesheet.groupboxes.visible = false)

Hope this is more clear like this

 
Upvote 0
I looked at your suggestion of the Active Xboxes. Yep, that's what I needed.

Thanks
 
Upvote 0

Forum statistics

Threads
1,214,833
Messages
6,121,858
Members
449,052
Latest member
Fuddy_Duddy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top