Help button
 

I have a userform. In this userform I want the user to be able to access a
users manual (preferably in the form of a .pdf-file). How the user can
access the users manual is of little importance as long as it is convenient
e.g. by pressing a button but preferably the user shall be able to click on
menu (as in word etc.) that is to be placed at the top edge of the user form.
However, I do not know who to make the button work or if possible to write
the code so that a menu is avaliable. Please if someone can help me I would
be most greatful.

Yours sincerly,

Fabrizio S.

Help button
 

This worked ok for me in xl2003 and winXP home:

Option Explicit
Private Sub CommandButton1_Click()

Dim myFileName As String
myFileName = "c:\somefilename.pdf"

Shell Environ("comspec") & " /c " & myFileName, vbHide

End Sub

Another option from John Walkenbach:
http://j-walk.com/ss/excel/tips/tip51.htm

Fabrizio wrote:

I have a userform. In this userform I want the user to be able to access a
users manual (preferably in the form of a .pdf-file). How the user can
access the users manual is of little importance as long as it is convenient
e.g. by pressing a button but preferably the user shall be able to click on
menu (as in word etc.) that is to be placed at the top edge of the user form.
However, I do not know who to make the button work or if possible to write
the code so that a menu is avaliable. Please if someone can help me I would
be most greatful.

Yours sincerly,

Fabrizio S.

--

Dave Peterson