I have a workbook with three sheets. In sheet 1 I have cell A1 where a macro controlled number will be found. In sheet 2 and 3 I have option buttons, called on and off (2 buttons in each sheet).

When I click the "ON-button" (in sheet 2) I want a macro to type a value of 1 in cell A1 in sheet 1. When I click the OFF button in sheet 2 I want another macro to type 0 in the same A1 cell in sheet 1. When clicking any of the two buttons I want to remain in sheet 2 so I don't end up in sheet 1 or experience "flashing" back and forth navigation between the two sheets.

I want to achieve the same things in sheet 3, preferrable, by using the same two macros. Clicking ON will set A1 in sheet 1 to value 1 and clicking OFF will set A1 in sheet 1 to value 0. Here too I want to remain in the sheet where the two buttons are.

Any help will of course be mostly appreciated.