I would like to have the ability to request a user (tab 1) to select a
value from a column of items on a seperate worksheet (tab 3) and then
fill a cell on worksheet 1 (tab 1) with that value.

Does that make any sense? I am guessing that I would need to use a
User Form to grab the choices and allow the user to select them?


---
Message posted from http://www.ExcelForum.com/

You need to make a listbox and set the data range of this to equal your
range of values on tab3. Then in the change event just add the code to copy
the value n the box to the cell you want.


"Jatherton " wrote in message
...
I would like to have the ability to request a user (tab 1) to select a
value from a column of items on a seperate worksheet (tab 3) and then
fill a cell on worksheet 1 (tab 1) with that value.

Does that make any sense? I am guessing that I would need to use a
User Form to grab the choices and allow the user to select them?


---
Message posted from http://www.ExcelForum.com/