userform 'helpfile'
 

Hi experts,

I have the following problem;

on my userform i have a button called 'help'.
when the user click this buttoni would like to show another form that
explains how my userform works.
This form would have
- something like 50 lines of text through which the user should be able to
scroll.
- a button to close it again

I do not know how to get a form to show such an amount of text (preferably
also formatted text).
Can anybody help me?

Thanks,
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

userform 'helpfile'
 

You could use a standard textbox on the userform with the Multiline property
set to True and ScrollBars set to fmScrollBarsVertical. That would allow you
to put many lines of text, but the better option for formatted text would be
a Rich TextBox Control, which you should be able to find in your "Additional
Controls" list (right-click on the Controls toolbox to get the list). It
allows you to have rtf text in a scrolling textbox.
--
- K Dales


"Pierre via OfficeKB.com" wrote:

Hi experts,

I have the following problem;

on my userform i have a button called 'help'.
when the user click this buttoni would like to show another form that
explains how my userform works.
This form would have
- something like 50 lines of text through which the user should be able to
scroll.
- a button to close it again

I do not know how to get a form to show such an amount of text (preferably
also formatted text).
Can anybody help me?

Thanks,
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

userform 'helpfile'
 

Hi Pierre

This is good:
http://www.j-walk.com/ss/excel/tips/tip51.htm

HTH. Best wishes Harald