Form Textboxes
 

I currently have a macro that will allow the user to enter
in a piece of information, will find that information on
the spreadsheet, open up a form listing that information
(and some other stuff) and allow the user to edit the
information. Ideally, when the OK button is hit, the now
edited information will be saved back into the correct
cells. I cannot get the information to go back to those
cells.

Suggestions?

Thanks

Pat

Form Textboxes
 

Just use the same information the user entered to find the information to
again

"find that information on
the spreadsheet,"

Then use that range as the basis for writing back the information.

set rng = Cells.find(textbox1.text)
rng.offset(0,1).Value = Textbox2.Text
rng.offset(0,2).Value = Textbox3.Text

--
Regards,
Tom Ogilvy



"Pat" wrote in message
...
I currently have a macro that will allow the user to enter
in a piece of information, will find that information on
the spreadsheet, open up a form listing that information
(and some other stuff) and allow the user to edit the
information. Ideally, when the OK button is hit, the now
edited information will be saved back into the correct
cells. I cannot get the information to go back to those
cells.

Suggestions?

Thanks

Pat