Inventory entry form

**o'h3nry** · 06-04-2010, 02:24 PM

Hello there, I've had trouble doing a good search for my problem, so I thought I'd try to explain it here.

When we get new inventory in, we add them to excel. There are many different specifications to each unit, such as year, make, length, options. We have many people entering the inventory, so when we try to do a sort/filter, it's inaccurate due to typos or different wordings.

I know how to make a data validation drop-down list but I don't want every SINGLE cell to have a dropdown. I'm wondering if there is a way to have a "master field" (like the Form feature) where you select the specifications for a single unit from a drop-down and hit "Submit" and it adds the unit to the inventory list. Perhaps this would be in the first few rows on top of a sheet.

If excel is capable of this (through features or VBA), could you point me in the right direction? Thanks in advance, ladies & gents.

**ConneXionLost** · 06-04-2010, 03:42 PM

Hope this helps:

Build a UserForm for Excel

Creating Advanced UserForms

Cheers,

**Richard Buttrey** · 06-04-2010, 03:45 PM

Hi,

If I understand your request it may be worth your while looking at Debrah Dalgeleish's web site, in particular the section that deals with dependent drop down lists.

See

http://www.contextures.com/xlDataVal02.html

HTH

**o'h3nry** · 06-04-2010, 04:13 PM

Thank you, both of you.

ConneXionLost, those links are exactly what I'm looking for. Apparently the term I've been looking for was "UserForm." I'll look into those and see if I can work my way through them... I've got the feeling I need to get more comfortable with VBA!

Richard, I'll look more into the dependent dropdowns as well.

Thanks again.

**o'h3nry** · 06-09-2010, 02:57 PM

Well, I made the example form following the instructions on the first liked PDF and now I have a question. Once I hit "ok", all of the userform input fields disappear until I hit "cancel" and open the userform again. I've attached a screenshot. Why does it do that?

Thanks- again- in advance.

EDIT: Well, I just pasted the code directly from the PDF and it works fine. Apparently it was an error of mine. I still don't know what it was though...