How to make a non-macro button/checkbox that when clicked will copy value out of that cell

[ladydubs]

What I have is cell a1, a2, and a3 that all have a different shade of red and each cell has a value set to it:

A1 = 1325
A2 = 1327
A3 = 1329

Cell B1 is blank.

I would like to be able to click on one of the colored cells and copy that value to B1. I cannot use macros.

Help please!

Thanks in advance.

[vamosj]

Here's an idea for you. This one has Radio buttons inline with A1, A2, and A3. These buttons are linked to cell C1. This is because Objects cannot be imbedded into a formula, so you have to use link the buttons to a cell. Cell C1's value is based on which button is selected. The formula is B1 then looks at the linked cell value and then selects the data in column A based on that value.

The linked cell can be adjusted to somewhere where it won't interfere with your data and also formatted to a white color so it won't be visible on the sheet, but I left it visable so you can see it at work.

[ladydubs]

This is exactly what I was looking for, thank you so much.

[vamosj]

Very welcome and glad I was able to assist