userform to display data and edit it

Hi all,

I need to build a userform that will allow me to display data from a worksheet and also to be able to edit it.

So far, I have managed to to do a search button that finds a value from the first column and based on that cell value, displays all values from that row.

Please Login or Register  to view this content.

The problem with this code is that it doesn't clear the textbox if I do another search. How can I achieve this?

Also, how can I code the Update button so that if a change one of the values displayed on the textboxes it will write it back to the worksheet?

Thanks.

Here you go. Make sure the variable rFind stays declared as a public variable:

Please Login or Register  to view this content.