+ Reply to Thread
Results 1 to 9 of 9

Make Combobox Contain URL links

  1. #1
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Make Combobox Contain URL links

    Basically the source cells for my combobox all contain URLs. However, in the combobox options, you cnanot click through to the URLS.

    How can this be achieved?

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Make Combobox Contain URL links

    hi spursrule68, how about making the cell beside it contain the URL?

    http://www.youtube.com/watch?v=p_77cZ1Vyl4

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Re: Make Combobox Contain URL links

    Quote Originally Posted by benishiryo View Post
    hi spursrule68, how about making the cell beside it contain the URL?

    http://www.youtube.com/watch?v=p_77cZ1Vyl4
    I'll take a look

  4. #4
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Re: Make Combobox Contain URL links

    Quote Originally Posted by benishiryo View Post
    hi spursrule68, how about making the cell beside it contain the URL?

    http://www.youtube.com/watch?v=p_77cZ1Vyl4
    no use unfortunately . Its because the combobox selections are news titles that are not links in themselves but have links attached to them.

    Baffling stuff :P

  5. #5
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Make Combobox Contain URL links

    hmmm, could you state some egs? do you mean it's the combobox selection is something like "Soccernet"? then maybe you can link it like this?
    =HYPERLINK("http://www."&A1&".com","Link")

  6. #6
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Re: Make Combobox Contain URL links

    problem is that the combobox references cells linked to a query! even more complex lol

  7. #7
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Re: Make Combobox Contain URL links

    anyone?????

  8. #8
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Re: Make Combobox Contain URL links

    alternatively, is this could be done for a lsit box it'd be great

  9. #9
    Forum Contributor
    Join Date
    02-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    172

    Re: Make Combobox Contain URL links

    on consideration list box is miles better

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1