title: Cells to automatically format entries as email hyperlinks
body: <p>Excel experts -</p>
  
  <p>I am dealing with a spreadsheet that has multiple macros running through it and has been extremely useful, however it does have one process that I would like to see if it is possible to automate, and so far my attempts and research has come up with nada.</p>
  
  <p>I have a userform entering in a client's email address directly into the next row of Sheet1 that is empty, and the email is in column H2:H3000.  There are several other tasks that Column H is already programmed to do, for instance, when the email is an active hyperlink and the user selects it, it generates an e-mail message through Outlook and within column K, anytime a hyperlink is selected, it records the date and time of the action, as well as the userID of who made the action.  The main problem with this current set-up is that, a user has to go through each cell in column H and double-click the email and click outside of it in order to activate the hyperlink.  Is there a way that this can be automated to any enter within Column H?</p>
  
  <p>Thanks!</p>