title: Formatting a URL into a Cell using VBA
body: <p>I think this is easy to do but after about 3 hours of Google fu I can't get an answer that works.</p>
  
  <p>I have a userform that asks for a ticket number then puts that ticket number in a cell, I want it to be a hyperlink.</p>
  
  <p>so cell A7 would be "1234567890"
  and the hyperlink would be "www.ticketsyustem.com/ticketID1234567890"</p>
  
  <p>is there a way to have this put in to the cell from the user form </p>
  
  <p>Thanks</p>