[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



  • 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.


    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


  • 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 :)



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!