+ Reply to Thread
Results 1 to 2 of 2

Help With Data Validation and Creating Messages

  1. #1
    Registered User
    Join Date
    08-23-2010
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Help With Data Validation and Creating Messages

    HI Everyone,

    So I have been working on a simple Project just for fun. Its a Excel Table That im using to track my Movie Collection and Store Data About DVD or Blu-Ray, etc. And also who borrowing it and stuff.

    Anyways, I have created Hyperlinks from the Movie Titles to A website that has info on movies. I wanted to make it So I can mouse over a cell and have a info box pop up. I can accomplish with Data Validation Input Message easily. But, I need something that moves when I Sort the Table, Data links to a cell and therefore Never Moves.

    Any Ideas you can give so i can do this for every Item on the List??

    Thank You!!

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Help With Data Validation and Creating Messages

    Hi
    In your cell references make sure that you have a "$" before the col and row numbers, this will ensure that the cell reference never changes even if it is moved.
    Good luck.
    Tony

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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