+ Reply to Thread
Results 1 to 2 of 2

Using a cell-linked text box to detect a calculated cell change and set value of scrollbar

  1. #1
    Registered User
    Join Date
    12-21-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    13

    Using a cell-linked text box to detect a calculated cell change and set value of scrollbar

    Hello everyone!

    I am attempting to automatically set the value of three active x scroll bars to 0 if a calculated cell's value changes.

    Given the calculate event can't have a range specified I am linking my calculated cell to a text box "TextBox1." I am then using the code below to theoretically detect the change and set all three scroll bars to 0 (Bars are named bbbar, ecbar, and ccbar)

    Can anyone help me figure out why this is not working?

    I have tried creating a active X textbox that is linked to the calculated value and then using this code to detect a change in the calculation but it is not working.

    Any ideas? I truly appreciate the help.

    Please Login or Register  to view this content.
    Last edited by darwin003; 01-13-2013 at 07:28 PM.

  2. #2
    Registered User
    Join Date
    12-21-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Using a cell-linked text box to detect a calculated cell change and set value of scrol

    Well I don't know much about coding so this took lots of trial an error but I needed to use the call function in combination with the above change event.

    Please Login or Register  to view this content.

+ 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