Editing data with userforms

**EDUcoordGR** · 09-01-2009, 12:22 PM

I have an inventory ws I am trying to put together and I am just learning how to use userforms. So far I am able to enter new items into my database using the userform I created, but I cant edit items that already exist.

I've attached a copy of my work in progress populated with a few sample items.

What I would like to be able to do is have my userform recognize when an item is already in the database (for example AAA) and then instead of inserting another instance of that item, have the userform either add to the quantity or subtract (if quantity in userform is neg).

I would also like the userform to update location. For example if a new shipment of AAA comes in and is stored in Loc 8 (whereas the old AAA is stored in Loc 5) I would like the database to display "Multiple" in the location cell for AAA.

I appreciate any help anyone can give a beginner like me.
Thank You

**Leith Ross** · 09-01-2009, 01:40 PM

Hello EDUcoordGR,

I modified your code to update the data and also select it on the worksheet, so the user can see what is being edited. I removed the item text box and replaced it with a ComboBox. This enables the product name to be stored along with its cell address on the worksheet. This makes referencing the worksheet much easier and faster since the product address can be retrieved from the control that selects the product. Here is the revamped code. It has already been added to the attached workbook.

Please Login or Register  to view this content.

**EDUcoordGR** · 09-01-2009, 02:06 PM

That's great. I was actually trying to use a combo box myself, but I couldn't quite figure out how to use it. The only other thing is that I would like to be able to add or subract from a total product quantity via the userform.

For example if FFF is already in the database with 160 units and I want to edit the database because I used 25 units I would like to be able to use the userform and put -25 in the quantity section and have it update to 135 instead of saying -25. Or if 25 more units of FFF came in I would like to be able to add those 25 units to the total.

Thanks