View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Forsyth Alan Forsyth is offline
external usenet poster
 
Posts: 5
Default Displaying Text on a Forms 2 Form


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