: I have a table in my Excel Spreadsheet consisting of two columns
: by 7 rows. The one column  consists of Code Numbers and the other
: a corresponding description.

How long are the descriptions? Can you provide an example?
Are these codes dynamic or static? (Do they change or always
remain the same?) Have you named the range where the table is?
Will there be different tables for other columns?


: I have to enter the codes in a column in another section of the
: spreadsheet I would like the table to appear when I select a
: cell  to enter a code in this column so that I can see its
: description without having to scroll back and forth to see the
: table.

Are you trying to learn the codes or can the VBA program
insert them for you? If you are no trying to learn them then
perhaps you could create a form with each description as an
option. Clicking on that option would then insert the code
into the cell.