Why not just use the built-in form, DataForm..?

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
ps.com...
Im looking for an example of something along this line.

On my userform1 I have a listbox, an edit button, a new button, and a
delete button.

I've gotten a list box to display A1:D8 which has 4 columns.

But I dont know were to even start as far as the edit button.
I would like it so that when I select the row in the listbox and press
edit, a new userform pops up, with 4 textbox displaying the row. Then
you can edit it, and click 'save changes' and it updates that row in
the list.

If anyone could either email me at or
post an example that could help me. I've spent hours seaching for
something like this but came up with nothing.

Thanks for the help
Mike