Show cells that are used for looking up information

C

Corey Thompson

I am building a spreadsheet for auditing process improvement progress.
It scores people on their adherence to the process on a scale of 0-9.
However, it is difficult to remember what the difference between say a
6 and an 8. I have an array of cells on one worksheet in the workbook
with definitions of the scores, but its cumbersome to Ctrl-PgUp to get
to it.

Is there a way to put the score definitions in a pop-up window, a
hidden something that shows up and goes away on a macro, etc? The
spreadsheet is about 500 lines long, so it would have to be location
relative.

Thanks in advance,
Corey
 
E

Earl Kiosterud

Corey,

You could put the scale on some top rows, then use Windows - Freeze panes
(first put the cursor just below the rows you want frozen on the screen).

You could use a modeless user form (Excel 2000 and up) with the scale on it.
This will require a little bit of code to make it appear. This could be
dragged around at will. The X button could be used to make it disappear.
 
C

Corey Thompson

How do I get the scale on the user form? Is it be possible to make the
form update as the cells that contain the scale information update?

I have the form appearing.

Thanks,
Corey
 
E

Earl Kiosterud

Corey,

You have to put some kind of control, like a text box, on the userform.

Why not put your scale in the top rows of the worksheet, and freeze the
rows. That'll keep it handy, and on the screen as the user scrolls.

Say more about your scale. What's in it? How many rows, columns?
 
C

Corey Thompson

It is about 20 lines long, so the freeze panes don't work as well as
they might (the data entry portions really need about 25 lines to work
well).

If I put a text box on the userform, how do I get the contents of a
range of cells, not only one cell, to display?

Corey
 
Top