Make a Textbox ready-only but able to scroll down text

[rtaboada]

I hope somebody can help me in this:

I have a TextBox control in one of my sheets with the vertical scroll bar working fine. The problem is that the text inside the textbox is editable. I don't want to be editable, just read only. The text was copied and pasted from a MS Word file. How I can make this work? I was thinking to convert the word file into another format (PDF of jpg) and then paste it to the textbox. The document is 6 pages long. Please let me know what I can do.

[mikerickson]

Have you set the Enabled property of the TextBox to False?

[rtaboada]

Thank you for responding.Yes, but by doing that the scroll bar won't work and I won't be able to read the whole text. Beside that, the text becomes grayed. Any other Idea?

[mikerickson]

I'm not familiar with ActiveX textboxes, but in a userform textbox, this code will prevent user entry into the box.

Please Login or Register  to view this content.

If your TextBox has a KeyPress event, it should work for you.

[rtaboada]

I am using a activeXcontrol text box because, in excel 2007,it is not available in the form control section. I can not find it. How I can make you code works?

[Apelcius]

out of curiosity, does Data>Validation (using a dropdown list, with the "ignore blanks" unchecked) not work for you?

[rtaboada]

But how I convert a 6 pages MS Word Doc into a Data validation list? So each line in the doc will be 1 item in the list? or the whole document one line item. However the text won fit in the cell, even if I merge cells. The scrollbar won't apear.