Print Dialog box

  • Thread starter Thread starter Bunny
  • Start date Start date
B

Bunny

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 here:
http://contextures.com/xlDataVal01.html

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

Debra also has notes about =vlookup() here:
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.
 
Back
Top