Ok this seems really elementary but...
I'm building a new spreadsheet that will contain a cell with text that will cause the cell to be bigger than a monitor and I'd like to add a scroll bar.
The easiest method seems to be to add an activeX text box in the cell, turn on multiline, scrollbars, wordwrap, etc.
Ok, I've done all that, but I want want the user to click on the textbox and be able to type, paste, etc data into the text box But I can't actually enter text in the textbox.
Am I missing something? When the textbox is clicked on in highlights it and shows the formula (=EMBED("Forms.TextBox.1",""). I can't type into the text box.
So how can I enable the user the type into the textbox, or is there another solution?
Thanks
I'm building a new spreadsheet that will contain a cell with text that will cause the cell to be bigger than a monitor and I'd like to add a scroll bar.
The easiest method seems to be to add an activeX text box in the cell, turn on multiline, scrollbars, wordwrap, etc.
Ok, I've done all that, but I want want the user to click on the textbox and be able to type, paste, etc data into the text box But I can't actually enter text in the textbox.
Am I missing something? When the textbox is clicked on in highlights it and shows the formula (=EMBED("Forms.TextBox.1",""). I can't type into the text box.
So how can I enable the user the type into the textbox, or is there another solution?
Thanks
