Inputbox in excel - how to? [Closed]

Report
-
 Trowa -
Hi guys

I would like to create a simple list of the things I buy.

I would like to have several inputboxes in which I can put the name of the product, the price, specs, dealer and so on.

I have some category labels to put on the different things: 'Computers', 'Displays', 'Audio' and so on.

So, I buy a new product, choose a category from a dropdown menu and punch in the rest of the info in the inputboxes. I hit enter / submit a the product will appear in my list.
How do I do this?

I run mac 2007 office - so no macros or VBA...

Hope you can help!

Best
- Jesper


1 reply

Hi Jesperhs,

Since you haven't given exact lists, let me give you an example.

Range A1:C2:
aa 12 !@
bb 34 #$

Select cell A4, goto top menus data > validate.
Allow: List
Source: A1:A2
Select cell B4, goto top menus data > validate.
Allow: List
Source: =IF(A4="aa",B1:B2,C1:C2)

When you choose aa from the first dropdown list the second one will let you choose either 12 or 34.
When you choose bb from the first dropdown list the second one will let you choose either !@ or #$.

With more categories you can use nested IF's.

Hopefully this gives you an idea how to tackle this query.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!