The textbox you use on a userform can be used on a worksheet as well (from
the control toolbox toolbar)

just put it on the worksheet and change the wrap, multiline and scrollbar
properties to reflect the behavior you want. The scrollbar won't appear
until the text exceeds the height of the visible area (given that vertical
scrollbar is enabled). You would need to set these if you used it on a
userform as well.

--
Regards,
Tom Ogilvy


"Fred Holmes" wrote in message
...
I've been using text boxes to post "notes" on my Excel worksheets.
They are fine for short notes but not for long ones. Is there some
sort of construct with a userform that I could try?

1. One could add / delete text to/from it as easily as a text box,
i.e., by directly editing it. No need to go into vba editor mode.

2. The form/control on the form would be of limited height, and one
could read the long text with a vertical scroll bar.

What control should I put on the userform to behave as above?

Thanks,

Fred Holmes