D Dave Peterson May 5, 2005 #2 What kind of dropdown (data|Validation, a combobox from the Control toolbox toolbar, a dropdown from the Forms toolbar)? And is it placed on a worksheet or is it a combobox in a userform? And what version of excel are you using? (I think you'll need a little VBA in any case.)
What kind of dropdown (data|Validation, a combobox from the Control toolbox toolbar, a dropdown from the Forms toolbar)? And is it placed on a worksheet or is it a combobox in a userform? And what version of excel are you using? (I think you'll need a little VBA in any case.)
D Debra Dalgleish May 5, 2005 #3 If you have a list of names and email addresses in your workbook: Name Email Al (e-mail address removed) Bea (e-mail address removed) Cal (e-mail address removed) Use data validation to create a dropdown list of the names (in cell B3 in this example). Then, in an adjacent cell, use a Hyperlink formula to create the email address, e.g.: =HYPERLINK("Mailto:"&VLOOKUP('Data Entry'!B3,NameLookup,2),B3)
If you have a list of names and email addresses in your workbook: Name Email Al (e-mail address removed) Bea (e-mail address removed) Cal (e-mail address removed) Use data validation to create a dropdown list of the names (in cell B3 in this example). Then, in an adjacent cell, use a Hyperlink formula to create the email address, e.g.: =HYPERLINK("Mailto:"&VLOOKUP('Data Entry'!B3,NameLookup,2),B3)
D Dave Peterson May 5, 2005 #4 After reading Debra's post, I'll change this line: (I think you'll need a little VBA in any case.) Click to expand... to (I think you'll need a little VBA in any case if you want to follow that link when you change the dropdown.)
After reading Debra's post, I'll change this line: (I think you'll need a little VBA in any case.) Click to expand... to (I think you'll need a little VBA in any case if you want to follow that link when you change the dropdown.)
