(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, 14 views)

I should elaborate as I have tried to use the ActiveX controls (Labels specifically). So I made something look like my text box: a rectangle shape with every line of text as a different ActiveX Label control all grouped together.

What I'm really unsure about is how to "link" this button box with whatever cell is active at the time, such that I can then click on the button box and subsequently select however many lines I need followed by disengaging the button box.

There is some macro work to be done here, but I'm not overly familiar with what options I have available in VBA to achieve this functionality.

Hi judicial,

I think you'd need a userform from which the user could select the various options. Oh, and you've got a few typos to fix on your textbox (I'm sure you'll lose marks for them)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]