View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jase jase is offline
external usenet poster
 
Posts: 117
Default TRUE/FALSE MACRO using Option Buttons

I have and IF statement with multiple TRUE/FALSE parameters. I am trying to
convert it onto a userform using option buttons. for example on my excel
sheet i have A1-A5 all false/true (with only 1 being true). How do I convert
this over to my userform using multiple option option buttons; each option
button linked to a cell A1-A5? If this is not clear please let me know.

basically if A1 is true, A2-A5 are false
if A2 is true A1 and A3-A5 are false, I need a macro on how to use this on a
userform