Thread: [Solved] Interactive Text Box?
View Single Post
 
Old 05-11-2011, 09:12 AM
judicial85 judicial85 is offline Windows 7 Office 2010 (Version 14.0)
Advanced Beginner
 
Join Date: Nov 2010
Posts: 64
judicial85 is on a distinguished road
Default

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.
Reply With Quote