View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Jensen Matt Jensen is offline
external usenet poster
 
Posts: 113
Default Cell Hyperlink - text, screen tip & link from other cells

Howdy
I want a cell in my spreadsheet to have text come from cell A1 (which is
easy to do obviously), a 'screen tip/text to display' from cell B1, and the
hyperlink URL to come from cell C1. Then I am going to copy this cell down
the page because I have a whole series of text/screentip/hyperlinks that I
want to do this way.
Can I do this, and if so how?
Thanks
Cheers
Matt