Can one with VB code set the max and min properties of a scrollbar to a cell ?
ie max= a1
min= b1
Can one set the scroll bar color and/or the knob (slider)
in VB to change relative to a cell value or value in excel
ie last > 100 Blue or .80*(a1)
last < 40 Red or 1.20 (b1)...
I have created a excel spreadsheet that imports ascii data thru webquery directly into the spreadsheet .
The information is date,time, trade price,trade size using a product called q collector for esignal and refreshes the data every 5 seconds
From the data I use certain array calculations to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.