+ Reply to Thread
Results 1 to 4 of 4

Link forms min/max value to a cell

  1. #1
    Registered User
    Join Date
    10-26-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    22

    Link forms min/max value to a cell

    Hi guys,


    Ive been trying to link the Min/Max Value of a scroll bar to a cell in the worksheet, I've found quite a few posts suggesting ways to do this with VBA, all of which i've tried but been returned with some kind of message saying it doesn't work (there have been 2-3 different messages - usually about debugging/Macro not found). All the other posts seem happy with the solutions so its probably something to do with where im putting the code they suggest
    Only just starting to pick up VBA, and by recording macro's and stepping in (tried this with this problem but couldn't get ti to work), so it would be really appreciated if any response was quiet specific (just patronise me its fine! )


    Thanks!

    Ben

  2. #2
    Registered User
    Join Date
    10-28-2012
    Location
    Poland
    MS-Off Ver
    Excel 2007/2010
    Posts
    94

    Re: Link forms min/max value to a cell

    hi,
    please see the attachement, but i'm not sure is this what you want.
    Attached Files Attached Files
    Like to say thanks ?Please use the star icon.

  3. #3
    Registered User
    Join Date
    10-26-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Link forms min/max value to a cell

    Hi,

    Amazing, not quiet what I was looking for but hadn't even thought of doing it like that and it was easy to adapt after you mentioned that!
    I used =IF(*Scroll link">= *Max Value*,*Max Value*,*Scroll Link*)


    Thanks!!

  4. #4
    Registered User
    Join Date
    10-28-2012
    Location
    Poland
    MS-Off Ver
    Excel 2007/2010
    Posts
    94

    Re: Link forms min/max value to a cell

    well, im glad that i could help

+ 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