email address in drop down list

[BenJAMMIN]

We are trying to get create a drop down list with names that have hyperlink email properties
I can get the list to display correctl
I can get the list to pull the data from Worksheet #2, which lists the names and has their email addresses embedded in them
But the list in the actual drop down list only displays the names....if I click on them it WILL NOT fire off my email program
I can select a name from the list and then Right Click>Hyperlink>email address>edit manually but I would prefer that this work automatically

Any thoughts/steps/ideas?

 

[Karl]

try this

need a combobox

Private Sub ComboBox1_Change()
ActiveWorkbook.FollowHyperlink Address:=Range("b1")(ComboBox1.ListIndex +
1), NewWindow:=True
End Sub

Private Sub Workbook_Open()
Sheet1.ComboBox1.List = (Range("a1", "a5"))
End Sub


is the example you need the list of names in sheet1 col a
the hyperlink ie mailto:[email protected]


just typed in not via the add hyperlink in col b

Dont know if it the correct way but it works !!

any more info / feedback please reply

We are trying to get create a drop down list with names that have hyperlink email properties.
I can get the list to display correctly
I can get the list to pull the data from Worksheet #2, which lists the

names and has their email addresses embedded in them.

But the list in the actual drop down list only displays the names....if I

click on them it WILL NOT fire off my email program.

I can select a name from the list and then Right Click>Hyperlink>email

address>edit manually but I would prefer that this work automatically.