This sounds like a great idea. However the cells that I will be pulling
from are not static.

I want to look up a customer from row 27 with SSN: xxx-xx-xxxx, and
then maybe I will look up the next customer on row 45. with ssn:
xxx-xx-xxx2.

How can I set the control source to a different cell based upon which
customer I look up. All of the SSN's will be from the same column, but
each ssn is on a diff. row.

WILL A CONTROL SOURCE WORK? OR IS THERE A ANOTHER SOLUTION?

Mike


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=274237

I have a similar case in the user inputting a number into a textbox. I
want this number to be transferred to a named cell in the workbook.
This named cell will be in various rows in a fixed column in the WB.
My textbox is working correctly, except when cycling through the
UserForm, the WB update is always one "cycle" behind the most recently
input number.

Any ideas?
Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=274237