Excel Adding Text to a Textbox in Excell


Joined
Nov 27, 2012
Messages
1
Reaction score
0
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
 
Ad

Advertisements

Joined
Nov 11, 2012
Messages
17
Reaction score
1
I believe the only way you would have
=EMBED("Forms.TextBox.1","")
showing is if youi are in Design Mode.
Go to the Developer ribbon and turn design mode off.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top