Updating Data in Workbook using UserForm

**DRkidd22** · 05-08-2009, 09:19 AM

Hello All,

This is my first post here and I've been trying to get this thing working for a while and have not been able to. I have created a userform that enters data into a spreadsheet just fine, but my problem is that I want to be able to search the spreadsheet using one or more of the fields that are also used to enter the data, say I may just need another button on my current form that will be called Find! and once pressed all data will be displayed on the userform ready to be edited by the user.

Any help will be usefull thanks.

**antoka05** · 05-08-2009, 10:41 AM

Try to use new 'FIND' command in 'RMADATAFORMS' form.
For example try to find 'rma' string.

I hope it can help you.

Regards,
Antonio

**DRkidd22** · 05-08-2009, 02:26 PM

That works great, but when I try to update the data it finds what it does is inserts new data line, I want to override/update the data i find

**antoka05** · 05-08-2009, 05:17 PM

See attached file.

Regards,
Antonio

**royUK** · 05-09-2009, 03:42 AM

Take a look at the databaseForm here

http://www.excel-it.com/vba_examples.htm
It can add, delete, find data

**DRkidd22** · 05-11-2009, 10:24 AM

Originally Posted by antoka05

See attached file.

Regards,
Antonio

Thanks for all your help man. I did some changes to the form. I've added three rows at the top for tittle, date and some other stuff, but now the issue is the headers in the find form are not coming up right. I tried making some changes to the coding, but since I'm new to this VB thing I couldn't figure it out, took me all night last night with no luck.

Also I've added a Total Line and a Percentage line. Is it possible to have the program automatically and rows above the Total line? I could add these two line at the top also and it shouldn't be a big deal right?

Thanks