How to update scroll bar position where min and max values depend on another cell?

Hello everybody,

I found the solution to set a scroll bar activex control with minimum and maximum values based on other cells in this forum link http://www.excelforum.com/excel-gene...croll-bar.html
i modified it and used the code as following:

Please Login or Register  to view this content.

E16 and F16 have formulas to lookup the min & max values of cell B16 in another table.(E16= minimum value & F16 =max value)
the scroll Bar is linked to cell G29

The problem is that each time the B16 changes, the scroll bar has to be clicked manually to update/refresh in G29, any way or VBA code to update the scroll bar position as per E16 value every time B16 changes?

Thank you very much for your help !

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

@gaftalik
I think your last post was a duplicate of post #4.
I "soft deleted " it. If there's any reason it should stay, give me a sign