M
Maria
Hello:
I would appreciate help on this one from you experts.
I am using a SPINNER CONTROL on Worksheet to change value of a target cell.
I do not want to use the Minimum, Maximum or incremental value provided with
the control but instead want to use something customized for the following
reasons
1) The minimum & maximum values for the Spinner control that I need to use
are not fixed but keep on changing since these values are derived from cells
A1 to A4. The spinner control does not allow reference to cells as its
minimum & max values and hence I am stuck at this stage.
What I would like to happen as the spinner control arrows are clicked, is
for the values of the target cell to change sequentially from A1 to A2 to A3
to A4. The target cell that I am using is cell B1
2) The second reason is that the min, max & increment values in Spinner
control are all whole numbers, while many of the values that I want to have
entered in the target cell B1 are less than 1.
Would sincerely appreciate your help
TIA
I would appreciate help on this one from you experts.
I am using a SPINNER CONTROL on Worksheet to change value of a target cell.
I do not want to use the Minimum, Maximum or incremental value provided with
the control but instead want to use something customized for the following
reasons
1) The minimum & maximum values for the Spinner control that I need to use
are not fixed but keep on changing since these values are derived from cells
A1 to A4. The spinner control does not allow reference to cells as its
minimum & max values and hence I am stuck at this stage.
What I would like to happen as the spinner control arrows are clicked, is
for the values of the target cell to change sequentially from A1 to A2 to A3
to A4. The target cell that I am using is cell B1
2) The second reason is that the min, max & increment values in Spinner
control are all whole numbers, while many of the values that I want to have
entered in the target cell B1 are less than 1.
Would sincerely appreciate your help
TIA