View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Qaspec Qaspec is offline
external usenet poster
 
Posts: 96
Default Find Values and Return Data

On my worksheet "Edit" I have a text box "tbFindName", a command button
"cbFindName", 3 text boxes "tbName", "tbNumber", "tbStatus" and a command
button "cbEdit". I also have a sheet "Data" that contains the values.

I need cbFindName to take the value in tbFindName, search the "Data"
worksheet
and return the corresponding values in the corresponding columns and rows
into tbName, tbNumber, and tbStatus.

Then if changes are made to the text box values (tbNumber is constant) I
need cbEdit to find the value in tbNumber, search for the corresponding
record (each record is in its own row and the record is made up of 3 columns
A:C) in "Data" and update the correct row of information in "Data".

Name is Data column A
Number is Data column B
Status is Data column C

Your help is appreciated.