Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Interactive Links in Excel (Excel 2000)

    Hello - I'd like to create a "Jeopardy" like environment in Excel and don't know if it can be done. I have 4 categories and 3 dollar amounts in each category. I'd like to incorporate a question behind each of the dollar amounts via a link. Does anyone know if Excel has the capability?

    Thanks! Trisha

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Interactive Links in Excel (Excel 2000)

    You can just add a comment that will display when cell is selected with no programming

    You could also use a user form and have the clicks move tdown layers dollars - question - answer if desired.

    You could also have a macro run when cell selected to move to another sheet
    There are lots of ways to do "in general terms" what you ask, so YES excel has the capability, it just matter what you really want and how extensive your skill level is.

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Interactive Links in Excel (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Trisha

    While waiting to catch a flight, I wipped this for you.

    <font color=red>This work is not tested, and needs a lot of improvments.</font color=red>

    Once I am back on solid ground, I'll try to enhance it, but for now, check and see if it is a starting point.

    BTW the questions I got were from the Jeopardy web site...

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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