Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom user help
Is there any way to have a popup window appear when the user presses F3 (or
some other F key)? I am trying to create some help capability for my users. Comments are useful but they interfere with the Validation windows for the same cell. I have written Winhelp files for Access but now I neex to know the best way to create "custom help" for an Excel workbook. Any general guidance would be appreciated. Bill |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom user help
Bill,
I don't think there is a "best" way to create custom help for Excel. John Walkenbach has one way here... http://www.j-walk.com/ss/excel/tips/tip51.htm Another way would be to display a message when a particular cell is double clicked. Also, the MsgBox function has the ability to display help. Yes, you can assign code to key strokes, see the OnKey method. As far as the built-in Excel help goes, I feel Microsoft "improved" help by making it harder to use and slower to respond. Compare XL 97 help to recent versions to see what I mean. Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Bill Jensen" wrote in message Is there any way to have a popup window appear when the user presses F3 (or some other F key)? I am trying to create some help capability for my users. Comments are useful but they interfere with the Validation windows for the same cell. I have written Winhelp files for Access but now I neex to know the best way to create "custom help" for an Excel workbook. Any general guidance would be appreciated. Bill |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom user help
Thanks Jim. How would I display a message box when a particular cell is
double clicked? "Jim Cone" wrote in message ... Bill, I don't think there is a "best" way to create custom help for Excel. John Walkenbach has one way here... http://www.j-walk.com/ss/excel/tips/tip51.htm Another way would be to display a message when a particular cell is double clicked. Also, the MsgBox function has the ability to display help. Yes, you can assign code to key strokes, see the OnKey method. As far as the built-in Excel help goes, I feel Microsoft "improved" help by making it harder to use and slower to respond. Compare XL 97 help to recent versions to see what I mean. Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Bill Jensen" wrote in message Is there any way to have a popup window appear when the user presses F3 (or some other F key)? I am trying to create some help capability for my users. Comments are useful but they interfere with the Validation windows for the same cell. I have written Winhelp files for Access but now I neex to know the best way to create "custom help" for an Excel workbook. Any general guidance would be appreciated. Bill |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom user help
Bill,
Code like the following placed in the worksheet code module... '-------------------------- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Select Case True Case Target.Address(False, False) Like "B4" 'Call your message box - might best go in standard module MsgBox "help" Cancel = True Case Target.Address(False, False) Like "C5" 'Call message box with different text MsgBox "more help" Cancel = True End Select End Sub '-------------------------- Jim Cone San Francisco, USA "Bill Jensen" wrote in message Thanks Jim. How would I display a message box when a particular cell is double clicked? "Jim Cone" wrote in message ... Bill, I don't think there is a "best" way to create custom help for Excel. John Walkenbach has one way here... http://www.j-walk.com/ss/excel/tips/tip51.htm Another way would be to display a message when a particular cell is double clicked. Also, the MsgBox function has the ability to display help. Yes, you can assign code to key strokes, see the OnKey method. As far as the built-in Excel help goes, I feel Microsoft "improved" help by making it harder to use and slower to respond. Compare XL 97 help to recent versions to see what I mean. Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Bill Jensen" wrote in message Is there any way to have a popup window appear when the user presses F3 (or some other F key)? I am trying to create some help capability for my users. Comments are useful but they interfere with the Validation windows for the same cell. I have written Winhelp files for Access but now I neex to know the best way to create "custom help" for an Excel workbook. Any general guidance would be appreciated. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom color palette does not get transferred with the workbook. Excel 2003 | Excel Discussion (Misc queries) | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
How do I write a macro for a button to send user to a custom view? | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
How do I share a custom toolbar with another user? | Excel Discussion (Misc queries) |