Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Radio button not working for duplicate worksheets
I have a work sheet that has 4 radio buttons that help users choose one of
the following: =IF(B12=TRUE,I8,0) =IF(B13=TRUE,I8,0) =IF(B14=TRUE,I8,0) =IF(B15=TRUE,I8,0) I have made 4 duplicates of this exact same sheet for example Earned Income Method (2) and so on. But what I have found is that once a user has clicked a radio button on sheet 1 if they use any of the other 4 sheets and click a radio button it un-clicks the 1st one losing their data. Is there any way to keep each worksheet radio button fuctions to itself?? Any help would be much appreciated! Thanks! ~Roxy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Radio button not working for duplicate worksheets
Hopefully someone else will be able to answer your question, but one minor
point is that I don't think you need the =TRUE =IF(B12,I8,0) should do it. -- David Biddulph "Roxy" wrote in message ... I have a work sheet that has 4 radio buttons that help users choose one of the following: =IF(B12=TRUE,I8,0) =IF(B13=TRUE,I8,0) =IF(B14=TRUE,I8,0) =IF(B15=TRUE,I8,0) I have made 4 duplicates of this exact same sheet for example Earned Income Method (2) and so on. But what I have found is that once a user has clicked a radio button on sheet 1 if they use any of the other 4 sheets and click a radio button it un-clicks the 1st one losing their data. Is there any way to keep each worksheet radio button fuctions to itself?? Any help would be much appreciated! Thanks! ~Roxy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Radio button not working for duplicate worksheets
AH! Your right that does work, thank you. I used the option button not from
the forms toolbox the other one, do you think that matters? Thanks again! ~Roxy "David Biddulph" wrote: Hopefully someone else will be able to answer your question, but one minor point is that I don't think you need the =TRUE =IF(B12,I8,0) should do it. -- David Biddulph "Roxy" wrote in message ... I have a work sheet that has 4 radio buttons that help users choose one of the following: =IF(B12=TRUE,I8,0) =IF(B13=TRUE,I8,0) =IF(B14=TRUE,I8,0) =IF(B15=TRUE,I8,0) I have made 4 duplicates of this exact same sheet for example Earned Income Method (2) and so on. But what I have found is that once a user has clicked a radio button on sheet 1 if they use any of the other 4 sheets and click a radio button it un-clicks the 1st one losing their data. Is there any way to keep each worksheet radio button fuctions to itself?? Any help would be much appreciated! Thanks! ~Roxy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Radio button not working for duplicate worksheets
Oh I think I figured it out, I just renamed each set of radio buttons and now
it seems to work. If this is not the right thing to do please somebody let me know. "Roxy" wrote: AH! Your right that does work, thank you. I used the option button not from the forms toolbox the other one, do you think that matters? Thanks again! ~Roxy "David Biddulph" wrote: Hopefully someone else will be able to answer your question, but one minor point is that I don't think you need the =TRUE =IF(B12,I8,0) should do it. -- David Biddulph "Roxy" wrote in message ... I have a work sheet that has 4 radio buttons that help users choose one of the following: =IF(B12=TRUE,I8,0) =IF(B13=TRUE,I8,0) =IF(B14=TRUE,I8,0) =IF(B15=TRUE,I8,0) I have made 4 duplicates of this exact same sheet for example Earned Income Method (2) and so on. But what I have found is that once a user has clicked a radio button on sheet 1 if they use any of the other 4 sheets and click a radio button it un-clicks the 1st one losing their data. Is there any way to keep each worksheet radio button fuctions to itself?? Any help would be much appreciated! Thanks! ~Roxy |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Radio button not working for duplicate worksheets
I don't think that was the fix.
My guess... You added optionbuttons from the control toolbox toolbar to a specific worksheet. Then you copied the optionbuttons from one sheet to another (or even copied the entire sheet). There's a property of the optionbuttons from the control toolbox toolbar called GroupName that tells excel how to group them together. (Kind of the way using a Groupbox with optionbuttons from the Forms toolbar groups them together.) In my guess, the optionbuttons were copied--that means the GroupNames didn't changed -- even though the optionbuttons are on different sheets. So show that control toolbox toolbar and click on the design mode icon. Then rightclick on each optionbutton in a group and give them all the same GroupName. Do the same with the optionbuttons on the second sheet, too (but use a different group name). FYI: The default groupname for these optionbuttons is the worksheet name--but you can use any valid name you like. Another thing to review is the LinkedCell property. Make sure each group points at the cell you want on the correct worksheet. Roxy wrote: Oh I think I figured it out, I just renamed each set of radio buttons and now it seems to work. If this is not the right thing to do please somebody let me know. "Roxy" wrote: AH! Your right that does work, thank you. I used the option button not from the forms toolbox the other one, do you think that matters? Thanks again! ~Roxy "David Biddulph" wrote: Hopefully someone else will be able to answer your question, but one minor point is that I don't think you need the =TRUE =IF(B12,I8,0) should do it. -- David Biddulph "Roxy" wrote in message ... I have a work sheet that has 4 radio buttons that help users choose one of the following: =IF(B12=TRUE,I8,0) =IF(B13=TRUE,I8,0) =IF(B14=TRUE,I8,0) =IF(B15=TRUE,I8,0) I have made 4 duplicates of this exact same sheet for example Earned Income Method (2) and so on. But what I have found is that once a user has clicked a radio button on sheet 1 if they use any of the other 4 sheets and click a radio button it un-clicks the 1st one losing their data. Is there any way to keep each worksheet radio button fuctions to itself?? Any help would be much appreciated! Thanks! ~Roxy -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Radio button not working for duplicate worksheets
Oh this was perfect, thank you so much I am still learning as I go. This was
exactly what I needed to do your a lifesaver! Thanks! "Dave Peterson" wrote: I don't think that was the fix. My guess... You added optionbuttons from the control toolbox toolbar to a specific worksheet. Then you copied the optionbuttons from one sheet to another (or even copied the entire sheet). There's a property of the optionbuttons from the control toolbox toolbar called GroupName that tells excel how to group them together. (Kind of the way using a Groupbox with optionbuttons from the Forms toolbar groups them together.) In my guess, the optionbuttons were copied--that means the GroupNames didn't changed -- even though the optionbuttons are on different sheets. So show that control toolbox toolbar and click on the design mode icon. Then rightclick on each optionbutton in a group and give them all the same GroupName. Do the same with the optionbuttons on the second sheet, too (but use a different group name). FYI: The default groupname for these optionbuttons is the worksheet name--but you can use any valid name you like. Another thing to review is the LinkedCell property. Make sure each group points at the cell you want on the correct worksheet. Roxy wrote: Oh I think I figured it out, I just renamed each set of radio buttons and now it seems to work. If this is not the right thing to do please somebody let me know. "Roxy" wrote: AH! Your right that does work, thank you. I used the option button not from the forms toolbox the other one, do you think that matters? Thanks again! ~Roxy "David Biddulph" wrote: Hopefully someone else will be able to answer your question, but one minor point is that I don't think you need the =TRUE =IF(B12,I8,0) should do it. -- David Biddulph "Roxy" wrote in message ... I have a work sheet that has 4 radio buttons that help users choose one of the following: =IF(B12=TRUE,I8,0) =IF(B13=TRUE,I8,0) =IF(B14=TRUE,I8,0) =IF(B15=TRUE,I8,0) I have made 4 duplicates of this exact same sheet for example Earned Income Method (2) and so on. But what I have found is that once a user has clicked a radio button on sheet 1 if they use any of the other 4 sheets and click a radio button it un-clicks the 1st one losing their data. Is there any way to keep each worksheet radio button fuctions to itself?? Any help would be much appreciated! Thanks! ~Roxy -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button to make multiple duplicate worksheets | Excel Worksheet Functions | |||
Help with radio button | Excel Discussion (Misc queries) | |||
radio button help | Excel Worksheet Functions | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |