ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Display on-screen information (https://www.excelbanter.com/excel-programming/359587-display-screen-information.html)

Phil H[_2_]

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?

K Dales[_2_]

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?


Phil H[_2_]

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?



All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com