Announcement

Collapse
No announcement yet.

VBA : Is there any way of creating a help file

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • VBA : Is there any way of creating a help file

    Hiya I have created a program in excel that is going out to users next month they have requested that a help file is included at the click of a button for each order they select! The problem is the help text for each order is too long to fit in a cell and I cannot have any external data files as they will not be able to be accessed by the customer! What is the best way to do this.. IS there anyway of creating a help file like the help files used in excel so I can have my own help at the click of the button with text that is not actually stored in worksheets

    Thanks
    A

  • #2
    You will need specialist software to do this, but you can program the Office Assistant to do this.
    Dim BalMsg As Balloon
    Set BalMsg = Assistant.NewBalloon

    With BalMsg
    .Animation = msoAnimationGetAttentionMajor
    .Mode = msoModeAutoDown
    .Icon = msoIconAlert
    .BalloonType = msoBalloonTypeNumbers
    .Heading = "J & R Excel Solutions"
    .Text = "Hello " & Application.UserName & "can you name the Ozgrid Moderator pictured here."
    .Labels(1).Text = "Do you need help?"
    .Labels(2).Text = "Try this."
    .Labels(3).Text = "It might help"
    .Labels(4).Text = "OK."
    .Show
    End With
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

    Comment


    • #3
      Can I do this part with out specialist software or do i need to get if even for the code snippet u included! What is the software i need?

      Comment


      • #4
        This code is VBA

        Dim BalMsg As Balloon
        Set BalMsg = Assistant.NewBalloon

        With BalMsg
        .Animation = msoAnimationGetAttentionMajor
        .Mode = msoModeAutoDown
        .Icon = msoIconAlert
        .BalloonType = msoBalloonTypeNumbers
        .Heading = "J & R Excel Solutions"
        .Text = "Hello " & Application.UserName & "can you name the OzGrid Moderator pictured here."
        .Labels(1).Text = "Do you need help?"
        .Labels(2).Text = "Try this."
        .Labels(3).Text = "It might help"
        .Labels(4).Text = "OK."
        .Show
        End With

        just run it fro a button or similar, amending to suit
        Hope that Helps

        Roy

        New users should read the Forum Rules before posting

        For free Excel tools & articles visit my web site

        If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

        RoyUK's Web Site

        royUK's Database Form

        Where to paste code from the Forum

        About me.

        Comment

        Working...
        X