blaksnm
Well-known Member
- Joined
- Dec 15, 2009
- Messages
- 554
- Office Version
- 365
- Platform
- Windows
Hey guys
I have a list of mail-adresses in range (B1:B10)
This list is the basis of the input in cell A1 by using data-validation-list.
Now I want the cell value in A1 function directly as a mailto-hyperlink - when activating the cell.
Of course I can choose the mailadresses by this validation, but the chosen value is just a value - not as a mailto-hyperlink.
Is this possible? and if so: how?
I have a list of mail-adresses in range (B1:B10)
This list is the basis of the input in cell A1 by using data-validation-list.
Now I want the cell value in A1 function directly as a mailto-hyperlink - when activating the cell.
Of course I can choose the mailadresses by this validation, but the chosen value is just a value - not as a mailto-hyperlink.
Is this possible? and if so: how?
