Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MikeyB
 
Posts: n/a
Default hyperlinks in drop down menu

I'm building a spreadsheet that will link users to the marketing material for
a range of promotional campaigns. Each campaign is limited to residents of
certain council areas. I currently have three drop down menus that specify
differing conditions. By selecting the council from the first drop down menu
it populates the second menu with the range of campaigns open to that area.
In the third drop down menu I would like it to display links to the different
promotional materials.

I have created a Look up chart for each campaign and can get the drop down
to return the text listed in these areas correctly but it wont provide them
in the form of links. Is it possible to hyperlink the values in the drop
downs or create a go button that will activate these links?

All help will be greatly appreciated as there seems to be no other
topics/threads with info on this!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with drop down menu Jrr6415sun Excel Worksheet Functions 4 July 10th 05 05:58 PM
How to create a drop down menu which referencing a different workb Joanne Excel Discussion (Misc queries) 1 June 18th 05 11:51 AM
Drop down menu Steve A via OfficeKB.com Excel Worksheet Functions 1 May 21st 05 12:57 AM
How do I set up a drop down menu within a drop down menu? Rob Excel Discussion (Misc queries) 1 April 12th 05 06:02 PM
Drop down menu Pong Excel Discussion (Misc queries) 12 March 22nd 05 09:34 PM


All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"