Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display on-screen information
I want users to click on an AutoShape to launch on-screen information/text -
but the text may be 1000 characters or more - instructions. What is the best way to do this? I like the look and operability of the message box. Can someone suggest an approach to this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display on-screen information
I would set up a user form and use the autoshape _click procedure to show it.
The form could have a textbox with the MultiLine property set to True; that gives you the ability to scroll the textbox if needed. For even more options (including formatting) you could use a RichText control (other controls) which lets you use RTF text. I would add a "CLOSE" or "OK" button to the userform to hide it again. It would act like a custom messagebox with plenty of room for text (without being too big). -- - K Dales "Phil H" wrote: I want users to click on an AutoShape to launch on-screen information/text - but the text may be 1000 characters or more - instructions. What is the best way to do this? I like the look and operability of the message box. Can someone suggest an approach to this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display on-screen information
Thanks for your help. I'll get started...
"K Dales" wrote: I would set up a user form and use the autoshape _click procedure to show it. The form could have a textbox with the MultiLine property set to True; that gives you the ability to scroll the textbox if needed. For even more options (including formatting) you could use a RichText control (other controls) which lets you use RTF text. I would add a "CLOSE" or "OK" button to the userform to hide it again. It would act like a custom messagebox with plenty of room for text (without being too big). -- - K Dales "Phil H" wrote: I want users to click on an AutoShape to launch on-screen information/text - but the text may be 1000 characters or more - instructions. What is the best way to do this? I like the look and operability of the message box. Can someone suggest an approach to this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to split screen & display 2 different workbooks? | Excel Discussion (Misc queries) | |||
DISPLAY TWO DIFFERENT SHEETS ON SCREEN | Excel Discussion (Misc queries) | |||
DEFAULT DISPLAY ON SCREEN | Excel Discussion (Misc queries) | |||
Worksheet won't display full screen | New Users to Excel | |||
Why is the information on preview screen differnt than on normal . | Excel Worksheet Functions |