Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
insert text into scanned form & keep forms original appearance | Excel Discussion (Misc queries) | |||
Displaying a User Form | Excel Programming | |||
Displaying forms in Excel with vb.net | Excel Programming | |||
displaying info on a form | Excel Programming | |||
Displaying form on startup? | Excel Programming |