Share via

Negative Scrollbar control

Anonymous
2015-05-29T06:16:32+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2015-06-06T04:08:05+00:00

    Would anyone like to comment, troubleshoot, resolve, collect info for developing a Update to fix the issue, ... other?

    Was this answer helpful?

    0 comments No comments