Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

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

  1. #1
    Join Date
    18th December 2003
    Posts
    26
    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,429
    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

    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.

  3. #3
    Join Date
    18th December 2003
    Posts
    26
    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?

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,429
    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

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Creating A .txt File
    By mhoctober in forum EXCEL HELP
    Replies: 4
    Last Post: April 2nd, 2007, 08:17
  2. Creating A New File With Code Of Its Own
    By coolhandphil in forum EXCEL HELP
    Replies: 4
    Last Post: March 2nd, 2007, 18:12
  3. Creating Text File
    By Bugsy in forum Excel and/or Email Help
    Replies: 1
    Last Post: October 28th, 2005, 04:25
  4. Creating a pdf file from a spreadsheet
    By Ranger in forum EXCEL HELP
    Replies: 20
    Last Post: April 2nd, 2005, 21:36
  5. creating a csv file
    By sdj1704 in forum EXCEL HELP
    Replies: 9
    Last Post: February 20th, 2004, 02:38

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno