Dropdown List

you can use VB to do this, but if your requirements for a dropdown listbox are rather minimal, there is a really easy way to do this:

in cells A1:A6, put your list of 6 values. put a box around this.

in cell C1 (put a box around this, too), click on DATA-->VALIDATION-->Allow List, in Source select A1:A6. Click OK.

in E1, the following formula: =C1

go to the box in C1 and choose any of the 6 items in the dropdown listbox. that's it really.

Caveat 1: you said, "send the result to a cell." in this example, you're actually 'receiving the result to the cell E1'. unless you were being very literal, the above instructions should suffice. if however, you DO want to 'send' results, then i think you need some VB macro.

Caveat 2: if the dropdown listbox doesn't work all of a sudden, check to see if your worksheet is WINDOW-->FREEZE PANES. if the worksheet has frozen panes, then dropdown listbox won't work...go figure.

han

Thanks Han - that worked well ( I really should do some reading up instead of pestering people ).

With regards to the result, is there an easy way to say that (e.g) if the result is '5', display picture 5 ? I need to make an easy shopping list displaying items chosen.

Thanks again.

Mac ( the non-reading )

i see what you're trying to do and it seems like a very cool application.

how are the pictures stored? in a dialogbox?

in any case, however, they are stored, i think your application will need some simple VB macro code.

i wish i could help, but i'm not a VB guru...i'm still learning. a good book on the subject is 'excel 2000 power programming with VBA' by john walkenbach. although it's a thick book, if you use the table of contents and the index intelligently, you should be able to create something in half a day. good luck.

han