+ Reply to Thread
Results 1 to 4 of 4

Font colour of text in MsgBox?

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Font colour of text in MsgBox?

    Hi i have a rather long message in my MsgBox but i want the email address to either be blue to stand out or linked so that the user can click on it and it will open up outlook with the email address already in the recepitent box. Is this possible?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Font colour of text in MsgBox?

    no-you need to create a userform and use that
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Crayford, kent
    MS-Off Ver
    Excel 2013
    Posts
    394

    Re: Font colour of text in MsgBox?

    Cheers for that, Im pretty much wrapped up on this now, so dont want to do that,

    Bacially i am trying to make this as simple as possble for the users "bearing in mind they like to push buttons and overwrite formulas" but they know how tho email so can i just make the email address bold? or do i have to do a aother userform for this?

    If so i think i will just leave it as it is and hope they can follow the instructions on the msgbox

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Font colour of text in MsgBox?

    you can't change the text font but you could put it on its own line separated from the rest of the message by blank lines

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1