Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Set Cell Equal to Selected Value from Dropdown.

Set Cell Equal to Selected Value from Dropdown.

Set Cell Equal to Selected Value from Dropdown.

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?

RE: Set Cell Equal to Selected Value from Dropdown.


"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.


glassesJust traded in my OLD subtlety...
for a NUance!tongue

"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!

RE: Set Cell Equal to Selected Value from Dropdown.

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.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close