[Solved] VBA: Assistant Balloons

  • Hi Guys,


    I was wondering if there is a simple way of inserting a hyperlink into the text of the Assistant.Balloon. I know of the [cf249] etc tags within the text to change to colours buts was curious to know if there was a flag for a hyperlink?


    Any assistance would be greatly appreciated


    thanks


    DW

  • This attached sheet achieves what you want but not maybe how you want it. Just press the button to open the assisantant and click the checkbox and click OK


    I'm still learning with the Assistant so someone out there might have a more "elegant" solution.


    HTH

    There are three types of people in this world.
    Those who can count and those who can't.

  • Thanks mate...at least it's a start for me and I can probably use it unti hopefully I can locate a 'cleaner' method but this works for my needs in the meantime.


    Thanks for your quick response


    DW

  • Hi DW,


    This takes Neale's example and replaces the checkbox with a label.
    The web address is given the appearance of a hyperlink.


    Cheers
    Andy

    [h4]Cheers
    Andy
    [/h4]

  • Hey Andy,


    Thanks for the update.....


    I noticed you used the {ul} key to underline the text in the balloon.Do you know of any others that can be used besides the {cf...}colour keys. Unfortunately I guess that there isn't a hyperlink key {hyp} perhaps :-)


    Thanks


    DW