Setting Value Of One Cell Equal To Value Of Selected Cell

S

Sheldon

Without using VBA - If cell A1=red, A2=white and A3=blue, can I set C1
to be the value of the selected cell so that if A1 is selected, C1
will equal red, if A2 is selected, C1 will equal white, etc.?
Thanks, Sheldon Potolsky
 
E

Earl Kiosterud

Sheldon,

In a word, no. No worksheet thing comes to mind that works as a function of the active cell.
You might want to use some radio buttons or a list box (Forms Toobar or Control Toolbox)
instead of cell selection. They'll let you click to make such choices, and you can use
formulas that will change a cell value as you wish.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation and drop-down list using IF, AND and what else? 8
***Help on writing a vba code 12
Cell colour change if formula displays false 3
SUM Question 6
cell formating 4
making cells uncopyable 1
Blank vs empty cells 5
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1

Top