View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roxy Roxy is offline
external usenet poster
 
Posts: 45
Default 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