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.
|