ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help Menu for Worksheet (https://www.excelbanter.com/excel-programming/347970-help-menu-worksheet.html)

DTTODGG

Help Menu for Worksheet
 
Hello-

I would like to know the best way to give "help" to a user filling out a
"form" excel file. I have several fields they must fill out, but I don't want
to clutter the worksheet with "fine print" unless they ask for help.

Maybe a popup, a right-click, a comment?

Thanks in advance

Peter Rooney

Help Menu for Worksheet
 
Hi,

How about:

CreateObject("WScript.Shell").Popup "Goodbye!", 1, " Goodbye for 1 second! "

The "Goodbye for 1 second" appears in the title bar of the popup, "Goodbye"
appears within the body of the popup and " , 1, " is the number of seconds
for which the popup stays onscreen until it disappears. The popup also has an
OK button that the user can use to dismiss it before it disappears under its
own steam.

Hope this helps

Pete


"DTTODGG" wrote:

Hello-

I would like to know the best way to give "help" to a user filling out a
"form" excel file. I have several fields they must fill out, but I don't want
to clutter the worksheet with "fine print" unless they ask for help.

Maybe a popup, a right-click, a comment?

Thanks in advance



All times are GMT +1. The time now is 09:55 PM.

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