Changing Row when Cell Changes

[rhoenig]

I'm working on a workbook that a user would like to change the contents
of Column B and once he clicks on another cell it will update the
specific row he just changed from a database.

Example.

User Changes Cell B1 to 1234. When the user clicks cell B2 or clicks
tab or enter the following will happen.

Row 1 will now populate specific cells with data gathered from a db
based on the entry 1234 from the user.

I've been playing with the worksheet_change routine but that updates
the cells when anything on the worksheet is changed. Is there a
routine that will only change when a cell in a specific column is
changed.

Thanks in advance.
Robert

 

[Frank Kabel]

Hi Robert
what do you mean with 'database' MS Access for example. Or do you mean
a differen worksheet (for the latter one you may use VLOOKUP)