That is correct. When the user is prompted to enter a value in the pop-up, E3 will be automatically populated with that value. I fixed a typo in my original code. Please use this one:
The macro is a Worksheet_Change event so it goes in the worksheet code module. Do the following:
-right click the tab that has your data
-click 'View Code'
-paste the code in the empty code module that appears
-close the code window
Make your choice in D3, exit the cell by clicking in another cell and see if it works properly for you.
Bookmarks