ActiveX Text Box with scrollbar

[TheMacroMan]

I have an ActiveX textbox with a vertical scrollbar. In an attempt to prevent editing, I did two things: the locked property is set to true, and the data is linked to a locked cell. The issue that I have run into is that (while the sheet is locked) I can edit one character at a time. Every time I enter something it pops up the "This sheet is protected" error, but still lets me change one character every time. Any thoughts?

As a note: setting the enabled property to false works to stop edits, but removes the ability to use the scrollbar, and the scrollbar is required.

 

[ChrisM]

Can you not just use a Label instead? Labels by definition are read-only.

 

[TheMacroMan]

Unfortunately Labels don't allow me to add the scrollbar.

 

[ChrisM]

Hmm, how about rather than linking the box to a live cell, why not break the link, and load the value of the cell in to the box during form load?

sub form_load
    MyTextBox = Sheet1.Range("A1").Value
End sub

Now anything you do in the textbox has no bearing on the worksheet.