View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Text Box Scroll Bars do not appear until you click in the text box

Rather than saying what the textbox is not, why not clarify what it is and
what you have attempted to do.

Is it an ActiveX Textbox, from the controls toolbox menu, placed on a sheet.
If so, and assuming you want your line breaks where you put them and not to
fit the width of the textbox, set MultiLine = true and Wordwrap = false.
Also of course scrollbars to show both.

It seems you need to set all those properties *before* you input the text.
If necessary, select-all (ctrl-a), cut & paste the text elsewhere, set the
properties as above, and paste the text back.

Regards,
Peter T

wrote in message
...
I do not know how to make the scroll bar appear all of the time. The
text box is NOT on a user form - and for reference, it is a lengthy
disclaimer.

I set it up by typing the disclaimer into the text box properties data-
text area, Everything works very well, except that the scroll bars
are not displayed until you click inside of the text box. Is there
any way to make the scroll bars appear all of the time?

I have tried to ask this question in several different ways, and I
have been experimenting with it for days without success. Please
forgive multiple similar postings, but I have only had one response
which suggested setting up a macro to move the box a bit each time,
and that did not work.

Thanks.