Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Assistant balloon option buttons (Excel 2000)

    I created an Excel App. and added a helpsheet as the last sheet in the workbook. When a person clicks a help button it activates the assistant, allowing them to navigate to the help of there choice. The code below is a small portion of the app! My question is: How can I get the option buttons to show. I had to suffice with the check boxes as I managed to get the code working, but the moment I used the option buttons (radio buttons) I could not get the macro running properly. Can someone help me with the code! To have the sample code run the assistant with option buttons so the user can only choose one of the list. Gratefully thanx. (Sorry, don't know how to preserve indents!)

    Sub WorkSheetsHelp()
    Set b = Assistant.NewBalloon
    With b
    .BalloonType = msoBalloonTypeButtons
    .Icon = msoIconAlertQuery
    .Button = msoButtonSetOK
    .Heading = "AutoMate Help"
    .Text = "Which sheet do you need help on! "
    .CheckBoxes(1).Text = "Input Data Sheet"
    .CheckBoxes(2).Text = "Switchboard"
    .CheckBoxes(3).Text = "Scorecards"
    .Show
    End With
    For a = 1 To 3
    If b.CheckBoxes(a).Checked = True Then
    Select Case a
    Case 1
    Sheets("HelpFiles").Select
    Set Target = Range("A26")
    'ScrollTo
    Case 2
    Sheets("HelpFiles").Select
    Set Target = Range("A49")
    'ScrollTo
    Case 3
    Sheets("HelpFiles").Select
    Set Target = Range("A110")
    'ScrollTo
    End Select
    End If
    Next a
    End Sub
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Assistant balloon option buttons (Excel 2000)

    Option buttons on a balloon are Labels. You need a callback function to handle them; look up Callback in the online help for an example.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Assistant balloon option buttons (Excel 2000)

    Thanks. I took the liberty of attaching the MS VBA Editor help file for "Callback" the this post if anyone needs a quick reference. Hans, in 2 short sentences, you have solved a problem that has bugged me for hours. How I why I did not see the callback method>>>I don't know. I searched the help files consistently to get help, but never spotted this page???
    Regards,
    Rudi

Posting Permissions

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