update

[enyaw]

I have a userform that allows a person to enter information into several
textboxes and output the information into a worksheet. Is there a way that i
could edit the information already put into the spreadsheet by searching for
a number and then recalling all the information for that number into the
userform?

[Kevin B]

If your data is in a contiguous table format w/column headings you might want
to consider using the built-in form accessed by clicking DATA and selecting
FORM. You'll want to move the cell pointer to a location in the table before
selecting the menu items. It would certainly save you a great deal of coding.
--
Kevin Backmann


"enyaw" wrote:

> I have a userform that allows a person to enter information into several
> textboxes and output the information into a worksheet. Is there a way that i
> could edit the information already put into the spreadsheet by searching for
> a number and then recalling all the information for that number into the
> userform?

[enyaw]

This would work fine Kevin but I need the information brought back to the
userform because there are calculations done on the userform before the info
is pasted. I would also need to overwrite the existing data when i am
finished editing.

"Kevin B" wrote:

> If your data is in a contiguous table format w/column headings you might want
> to consider using the built-in form accessed by clicking DATA and selecting
> FORM. You'll want to move the cell pointer to a location in the table before
> selecting the menu items. It would certainly save you a great deal of coding.
> --
> Kevin Backmann
>
>
> "enyaw" wrote:
>
> > I have a userform that allows a person to enter information into several
> > textboxes and output the information into a worksheet. Is there a way that i
> > could edit the information already put into the spreadsheet by searching for
> > a number and then recalling all the information for that number into the
> > userform?