VBA: Update worksheet when txtBox data changes.

[Mcasteel]

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

I want to look up a customer from row 27 with SSN: xxx-xx-xxxx, an
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 whic
customer I look up. All of the SSN's will be from the same column, bu
each ssn is on a diff. row.

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

Mik

 

[Chuckles123]

I have a similar case in the user inputting a number into a textbox.
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 th
UserForm, the WB update is always one "cycle" behind the most recentl
input number.

Any ideas?
Chuckles12