#1
|
|||
|
|||
Interactive Text Box?
(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 Last edited by judicial85; 05-11-2011 at 09:13 AM. |
#2
|
|||
|
|||
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. |
#3
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using hyperlinks to create interactive menus | hongkongphooey | PowerPoint | 0 | 01-25-2011 07:30 AM |
Objective: Automatically export email text,attachment text to DB friendly format | SilentLee | Outlook | 0 | 11-14-2010 02:45 PM |
Interactive Word Form. | micropc | Word | 0 | 01-05-2009 05:59 PM |
training - interactive cd's?? | aceensor | Excel | 0 | 04-28-2006 07:31 AM |
training - interactive cd's?? | aceensor | Word | 0 | 04-28-2006 07:29 AM |