Excel 2003 VBA searching and editing data using a userform?

[jazzychrissy]

Hey!
I have a lot of data on an excel spreadsheet which has many columns for different required fields of pieces of data.
New data can be input using a user form, and this works well. However now i would like the user to be able to search for a row of data and update/edit the details of this data using a userform. How can i do this? (I have already figured out how to use the Search command, just cant do the updating!)

 

[Norie]

You could certainly do this with a userform, but why not first try Data>Form...

 

[jazzychrissy]

You could certainly do this with a userform, but why not first try Data>Form...

Thanks! thats really helpful.
I recorded a macro that searched for the data, and brought up the "data form" you referred to. However, when this menu came up, it did not bring the searched data up. it simply brought the first data in the spreadsheet up instead....
Any ideas how i can fix this?
Thanks

 

[Norie]

I think I seen problems previously when trying to call the in-built form using code.

I'm sure it's possible, and I'm sure you can get it to display the correct data - might be something to do with what cell/range is selected.

I've got to admit I would probably favour a userform since it will give you far more control over what's going on.

But the drawback is that you would need to write all the code for searching, deleting, editing etc.

That might be quite a task to try but once done it's done, and plenty of other people have done it before.

And some of those people have posted code/add-ins etc, so a web search might not be a bad idea.