MakeProgressionBar a, 1, 20, 10, 10, 3, 1, 20
MakeProgressionBar a, 1, 40, 10, 15, 14, 1, 20
MakeProgressionBar a, 1, 30, 10, 20, 1, 1, 50
MakeProgressionBar a, -10, 30, 10, 24, 5, 1, 70
'MakeprogressionBar is a sub that makes as output a progression bar with colored the part showing the value num on the total L
' num is the value to show
' min and max are boundaries of the range in which num stands
' x and y are the row and column where progressionbar is showed
' cfill is the color of filled part
' Nmin and NMax are the boundaries of the new range in which num must be showed
nRange = (nMax - nMin) + 1
nVal
= CInt((nRange
* num
) / ((max
- min
) + 1))