• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Break link between 2 radio buttons

Dokat

Member
Hi,

I have 2 tables with radio button to sort. There is a link between radio buttons so if select one it automatically sorts the other table as well. I tried group box(form control) to break the link however i was unsuccessful. Can someone come across similar issue and have a solution?

Thank you
 
Dear Dokat,
do you want to remove link between two radio button?
can you upload sample worksheet ?
 
Yes i do want to remove the links between two radio buttons. My worksheet is too big to upload and link to each other
 
Hi ,

You cannot have only one radio button.

It may start off unchecked , but once you have checked it , you will not be able to uncheck it.

If checking a radio button will sort the relevant table , what is supposed to happen if you could uncheck the radio button by putting its linked cell to 0 ?

Why can you not use a check box which can be checked and unchecked ?

Narayan
 
Hi,

Thank you for your response. I want radio button to sort relevant table. But it's also sorting the second table. I have two seperate tables. Each Table has 5 radio buttons so total of 10. I'd like to remove the link between the radio buttons (5) in first table and second table (5). I tried putting a check box however the issue is table is dynamic one with formulas and when i sort with check box/macros it doesnt work right.

Also i change the link cell in format control however it reverse itself the minute i close format control.

Hope this makes sense.

Thanks
 
I tried the groupbox it didnt work the first time. i will try it again with first putting the groupbox and then inserting radio buttons.

Thanks
 
Hi

I deleted and recreated the groupbox and new radio buttons however it didnt work. Are there any other workaround?
 
Hi ,

The website displays this message :

The free hosting period for this file has now expired, only premium users can download it.

Secondly , the file size is just 204 KB , and this forum accepts files of size up to 1 MB.

In case you want the file to remain confidential , please email it to me at :

tech [dot] support [at] chandoo [dot] org

Narayan
 
Back
Top