Set Cell Equal to Selected Value from Dropdown.

[grnzbra]

I have a column of dropdowns. I would like to be able to set cell A1 (it can be any given cell) equal to the value selected from the dropdown. Is there any way of doing it with Excel functions rather than using macros?

 

[SkipVought]

Hi,

"I have a column of dropdowns." Plural
"the value selected from the dropdown." Singular

Help us out!

But I strongly suspect that you might need to employ Event processing in a VBA procedure.


Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[combo]

In Excel you can use:
- data validation, with a list of permitted values. In this case a drop-down arrow appears when the cell is active. It is possible to add entry and error messages,
- forms dropdown, with a list in range and linked cell as target.

In both cases value selected appears in the cell.
In the first case user can still clear cell contents or paste value not in list.
In the second case user can write any value in linked cell.

combo