Forum Discussion
Solved
Changing the Value of Option Buttons
Please help me change the value of the first of two option buttons from a "1" to a "0" and the second from a "2" to a "1". Regards Terry
Terry_Twala Allow me to be simple. If you have 2 buttons in your sheet the linked cell will display which button was pressed. I.e. either the first or the second. button Not the -zero-th or the first. If it is important that you must use a 0 or a 1 then take the value of the linked cell minus 1. Thus, 1 becomes 0 and 2 becomes 1.
Hello, you can check the link below for a guide
https://trumpexcel.com/insert-use-radio-button-in-excel/
https://trumpexcel.com/insert-use-radio-button-in-excel/
Thank you Abiola1 I will check it out.