userform, email enter in cell WITH HYPERLINK!

[dsgs]

Hi I have a userform that amongst others contain "email".
The entered value in this textbox is allways correct (through filters) but i'd like to store the value as a hyperlink!

so:

    Range("G3") = email2

should be something like:

    Range("G3") = email2 as hyperlink

any ideas?

thanx!

 

[Andrew Poulsom]

Try:

Range("G3").Hyperlinks.Add Anchor:=Range("G3"), Address:= email2

 

[dsgs]

Hi Andrew,

thanx for your help, i tried your code but the link doesn't work! for instance i entered david@soeten.nl and it searched for the file david@soeten.nl not opened a email to....

 

[Norie]

dsgs

Where are you entering the address?

What is email2?

 

[dsgs]

Hi Norie,

I'm using a userform with a textbox ("email2"). this should be placed in range("G3") when i click "toevoegen" (button).

i also tried the help function that looked like this:

With Worksheets(1)
    .Hyperlinks.Add Anchor:=.Range("a5"), _
        Address:="mailto:someone@microsoft.com?subject=hello", _
        ScreenTip:="Write us today", _
        TextToDisplay:="Support"
End With

i didn't get it to work eigther.

what i'm i doing wrong?

 

[Norie]

What doesn't work with the help example?

I tried it and it created a hyperlink in A5 which when clicked opened a new mail message to someone@microsoft.com.

 

[dsgs]

The example does work but i'd like to use the email adres entered in textbox "email2", i don't like a prewritten subject, the text to display should be what is entered in "email2" and i don't want a screentip. when i changed these things i probebly did something wrong because i couln'd get it to work again....

 

[dsgs]

i finally managed to get it to work:

    Range("G3").Hyperlinks.Add Anchor:=Range("g3"), _
            Address:="mailto:" & (email2), _
            TextToDisplay:=(email2)

 

[dsgs]

thanx for all help! and pointing me in the right direction

 

[Norie]

dsgs

Small matter but do you really need the brackets () around email2.