A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Would anyone like to comment, troubleshoot, resolve, collect info for developing a Update to fix the issue, ... other?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The below excerpt from the Win Excel 2007 Help file for Developers indicates that the Scrollbar form control can indeed handle negative vales down to -32767. After setting its Max & Min properties to the desired limits and establishing the LinkedCell, operations using the Scrollbar result in the LinkedCell value wrapping to 65535 once the intended value becomes negative. Obviously, this is not as described in the Developer Reference copied below. Is there a Fix-It/Tweak/Regedit for this bug?
| Max, Min Properties |
|---|
Specify the maximum and minimum acceptable values for the Value property of a ScrollBar or SpinButton.
Syntax
object.Max [= Long]
object.Min [= Long]
The Max and Min property syntaxes have these parts:
| Part | Description |
|---|---|
| object | Required. A valid object. |
| Long | Optional. A numeric expression specifying the maximum or minimum Value property setting. |
Remarks
Clicking a SpinButton or moving the scroll box in a ScrollBar changes the Value property of the control.
The value for the Max property corresponds to the lowest position of a vertical ScrollBar or the rightmost position of a horizontal ScrollBar. The value for the Min property corresponds to the highest position of a vertical ScrollBar or the leftmost position of a horizontal ScrollBar.
Any integer is an acceptable setting for this property. The recommended range of values is from –32,767 to +32,767. The default value is 1.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Would anyone like to comment, troubleshoot, resolve, collect info for developing a Update to fix the issue, ... other?