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
- Show quoted text -
Thanks. I am self-taught, and so some of your terminology is a touch
above my head, but I think I understand at least a little bit as to
what you are saying.
I learned to program originally in Fortran using punch cards on an IBM
computer with 8 large tape drives and a CPU that would fill a small
house (yes I am that old). I think it had less computing power than
my I-phone, but it seemed wonderful at the time. I have been self
taught since then, learning to use Excel and VBA primarily by trial
and error. Without this user group I would still be treading
water.
I am telling you this to try to explain why I have some difficulty
answering your question. I am not sure if it an ActiveX or not. I am
not even sure what ActiveX means.
I did create the listbox with the scroll bars from the toolbox, if
that helps explain. The page with the textbox disclaimer opens up
whenever someone begins to use the program, and it contains the
disclaimer begs the user to please not sue me if something in the
program does not work. If they accept, the program opens.
It is simply a program to keep score in a marching band competition,
where many varied awards can be presented at the option of the
competition sponsor. The program also prints out a list of the
winners in these categories so that the user (usually an untrained
soccer mom) can print out the winners at the end of the contest and
simply read the winners while the kids stand on the football field to
accept their awards. Then the completed program is sent back to me
and the scores are used to qualify the bands for a state tournament at
the end of the season.
I wrote the original program years ago, and have added to it each
year. The program has ballooned to an unreasonable size, and I am
trying to pare it down, so this year I am doing a total rewrite to try
to clean up the junk that I added out of ignorance and trial and error
over the years. I hope this answers all of your questions. If not,
let me know.
I will give the multi-line approach a try. If that does not work, I
think I will just put some verbage on the page (which is designed to
look something like a userform) and tell the user to click in the box
to acivate the scroll bars. it is a bit less elegant, but I am 99.9%
sure it would work, anyway. I appreciate your response very much.