Can i refresh a dropdown selection?

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,744
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hi Everyone,

Not sure if this is possible?
It a little unusual so please Read before commenting thank you.

I have a drop down list,
and in that list i have some cell which change based on other details in the document,
for example,
Dropdown example
Tony has ears (however because the name can change in the document "Tony" is ref from cell "A1" so its actually ="A1" & " Has Ears")
Tony Has no ears
Tony is an idiot
This list is just an example.

Now the problem is,
if i go to my dropdown list and choose the persoons name,
then select a dropdown, i get the name, but if the name changes the drop down does not because its only a dropdown, it doesnt have the "A1" & " Has Ears" formula in it.

so is there a way i could get the dropdown box to show the current name not just the one it had when i selected the drop down?

i.e. can i make the dropdown live?

thanks

Tony
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Candyman8019

Board Regular
Joined
Dec 2, 2020
Messages
138
Office Version
  1. 365
Platform
  1. Windows
I would create a list, perhaps on another sheet that you can hide later, that contains your values, ie:
=A1&" Has Ears"
=A1&" Has no ears"
etc.
name the range accordingly. Then, on your validation dropdown you can use list ={range name} which will always reference whatever values are in that named range.
 

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,744
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hi Candy name,
i'm not sure if that will work as i still get the same fixed wording in the dropdown? i think,
but i;ll give it a try and if it does work i'll let you know
 

Candyman8019

Board Regular
Joined
Dec 2, 2020
Messages
138
Office Version
  1. 365
Platform
  1. Windows
It definitely works. I use that functionality in some of my sheets.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,404
Messages
5,641,940
Members
417,249
Latest member
Quysinboy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top