View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Randy L Randy L is offline
external usenet poster
 
Posts: 27
Default Non VB (simple VB) Hyperlink Data Validation List

Once you create the list of long addresses, you can right click on each one,
select Edit Hyperlink, and then type in what you want to appear for that link
in the "Text to display" box.

"ric.todd" wrote:

Can't get this figured out.

Need to make a list of hyperlinks drop down that is populated from a
separate wsheet. The real catch is I need to use simple titles for long
hyperlinks (ie. google for http://www.google.com) simialr to a an html
dropdown menu.

I am very new to this so go easy on me, please.

Thanks in advance,

rt