(Part of my attempts at this problem are posted below in a reply to this now)
Hello,

I am trying to build an easy-to-use and intuitive marking scheme (see attached).

This would be my ideal scenario:
- I click on a blank cell in one of the "!" columns
- it brings up (or waits for user input) from the orange text box object
- each text line clicked by the mouse adds the corresponding code (1a, 3d, etc) to the column
- disengage the interaction through "Tab" or "Enter" or a "Close button"

Is this realistic for Excel? If so, what would be my best approach?

Thanks for any advice,
Bryan

Attached Images

Marking Scheme.jpg (70.4 KB, 16 views)