EXCEL Checkbox 2

In EXCEL – ‘Sheet 1’, I create a 3 checkboxes using the checkbox tool from the toolbar. In the cell next to each checkbox, theres a corresponding value.

Depending on which checkbox the user selects the corresponding value in the adjacent cell should be displayed automatically on ‘Sheet 2’.

What is the VB code or macro that can accomplish this?