I'm using Excel 8 and I have a sheet where I want to display from about a
paragraph up to about two pages of text when a user clicks in a
particular cell in a row.

I have no problems whatever with showing the Form and the text, but I
need some very basic Forms 2 help with the display of that text.

I want to disable edits, have no cursor, display the text so that it can
be read from the start rather than from the end and have a vertical
scrollbar when required.

A Label does what I want except for scrolling.
Can a user scroll through text on a Label? (he said, expecting the
answer, "No.")

A textbox does what I want when Enabled and Locked, but I'd need to
reposition the text within the Textbox so the user can start reading from
the top, and I'd like to remove the cursor to show that the text can't be
edited.
I feel I should be able to use SelStart and SelLen, but my tests leave
the text still showing the last section rather than the first.

I'd be grateful for help in these four goals:

1. Disable edits.
2. Have no cursor.
3. Display the text so that it can be read from the start.
4. Have a vertical scrollbar when required.

Thanks for any suggestions.

Alan Forsyth

Use a textbox, select LOCKED, scrollbars=2 (vertical), TextBox1.SelStart = 0
to bring the cursor to the beginning, and i have no clue on the cursor,
anything i do to get rid of it gets rid of scrollbars as well.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Alan Forsyth" wrote:


I'm using Excel 8 and I have a sheet where I want to display from about a
paragraph up to about two pages of text when a user clicks in a
particular cell in a row.

I have no problems whatever with showing the Form and the text, but I
need some very basic Forms 2 help with the display of that text.

I want to disable edits, have no cursor, display the text so that it can
be read from the start rather than from the end and have a vertical
scrollbar when required.

A Label does what I want except for scrolling.
Can a user scroll through text on a Label? (he said, expecting the
answer, "No.")

A textbox does what I want when Enabled and Locked, but I'd need to
reposition the text within the Textbox so the user can start reading from
the top, and I'd like to remove the cursor to show that the text can't be
edited.
I feel I should be able to use SelStart and SelLen, but my tests leave
the text still showing the last section rather than the first.

I'd be grateful for help in these four goals:

1. Disable edits.
2. Have no cursor.
3. Display the text so that it can be read from the start.
4. Have a vertical scrollbar when required.

Thanks for any suggestions.

Alan Forsyth

Yes, that's where I've ended up.That cursor just doesn't want to die.

Thanks anyway.


?B?Sm9obiBCdW5keQ==?= (remove) wrote in
:

Use a textbox, select LOCKED, scrollbars=2 (vertical),
TextBox1.SelStart = 0 to bring the cursor to the beginning, and i have
no clue on the cursor, anything i do to get rid of it gets rid of
scrollbars as well.