Hi MarvinP, i do have those option button values set to True. When the userform opens the option buttons are set to No like i need...but when i click the add button it should return the result of "0" into a specific cell....if i dont click on any of the option buttons and i click the add button it returns no value even those the option button is on.