Avoid the use of vba or formulas to do this.
This tip only works with the form control scroll bar.
Just format the linked cell with a custom cell format like this 0"%".
Don't use the embedded percent cell formats only a custom format.
Only works with whole numbers not fractions of a percent.
Hope this is of some help.
Bookmarks