Thread: Yes or No Button for multiple functions?

I need to create a yes and no button that will have multiple function depending on a cells content. For example: I have a yes and no button and in cell A1 it says you have found a gold coin, do you wish to pick it up? Yes would then add 1 coin to cell A3 and No would leave the coin in cell A1. However, if A1 were to display 2 coins I would need the yes button to calculate picking up 2 since that's how many are in the cell.

Can anyone help me with this?

Hi

What sort of Yes / No buttons are you talking about? Togglebutton, option buttons???


rylo