+ Reply to Thread
Results 1 to 3 of 3

Can a Form textbox become a hyperlink?

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    Can a Form textbox become a hyperlink?

    On a form I have it takes its data from a spreadsheet.

    One textbox on the form displays data from a cell on the spreasheet that is an email address.

    On the spreadsheet the email address can be "clicked" and that opens up the email client with the clicked address as the "To:".

    The form displays the email address as text, not an email hyperlink.

    Can the form show the email address as a clickable email hyperlink?

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Can a Form textbox become a hyperlink?

    I presume you want the text in the textbox to look like a hyperlink and behave like a hyperlink. So

    1. format the font to be underlined and the forcolor to be blue
    2. use the dblClick event on the textbox to startup the email


    click on the * Add Reputation if this was useful or entertaining.

  3. #3
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    Re: Can a Form textbox become a hyperlink?

    I like that!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. TextBox Hyperlink Code
    By oskar44 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-02-2015, 09:03 AM
  2. Open hyperlink from textbox (Help) please
    By lacromo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2015, 12:08 AM
  3. [SOLVED] vba: copy value of textbox to another textbox in another form
    By saikong051 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2014, 04:05 PM
  4. [SOLVED] User Form - Hyperlink Button within a Form, to create a Link on a Designated Cell
    By Sinalk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 07:29 AM
  5. how to extract hyperlink from textbox
    By rramoutar7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 06:52 AM
  6. Hyperlink within Textbox(UserForm)
    By Soniya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2005, 01:20 PM
  7. Hyperlink in a textbox
    By GWI in forum Excel General
    Replies: 1
    Last Post: 02-15-2005, 01:06 AM

Tags for this Thread

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