Form Textboxes

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

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
 
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
 
Back
Top