Is it possible in excel to create a box which will pop up when you click on a
cell so that you can type in a code and all details for that specfic code get
printed out

Maybe...

I would think that one of the easiest ways to implement the "box" would be to
use data|validation (in the Data|Validation option in xl2003 menus).

The list would be the leftmost column on a separate worksheet (nicely named!)
and the other info would be in columns B:xx.

Then you could use =vlookup()'s to return the associated values for that chosen
option.

Debra Dalgleish has some notes on data|validation starting he
http://contextures.com/xlDataVal01.html

And how to name that first column he
http://www.contextures.com/xlDataVal01.html#Name

Debra also has notes about =vlookup() he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble

====
You may want to use a formula like:
=if(a1="","",vlookup(a1,sheet2!a:x,12,false))

Where A1 is the cell with the data|validation value. And Sheet2 is the sheet
with the table (A:X) and you want to retrieve column L (12th column in that
range). False means that you want an exact match.



Bunny wrote:

Is it possible in excel to create a box which will pop up when you click on a
cell so that you can type in a code and all details for that specfic code get
printed out

--

Dave Peterson