ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Spinners - minimum and maximum (https://www.excelbanter.com/excel-discussion-misc-queries/109348-spinners-minimum-maximum.html)

Brad

Spinners - minimum and maximum
 
I have one spinner that has a limitation of 1 to 51 - with a step of one.
(no problem)

I have another spinner that I would like to have a limitation of 1 to
(52-spinner 1).

I'm having problems with (52-spinner 1) limit. Data validation isn't
working - what do I need to do?

What I'm trying to do is allow the user to select which week will be their
start week (for graphing) and then be able to go - a selected number of weeks
after that (and I would like the spinners to be smart enough not to exceed 52
weeks) - Could one spinner do this? I realize I have just asked two
questions.

Kevin B

Spinners - minimum and maximum
 
Make sure that the Controls tool bar is visible and click the design mode
button to activate design mode.

Right click on your spinner control and select properties and set the
Min/Max values for the spinner. Close the properties window and exit design
mode.
--
Kevin Backmann


"Brad" wrote:

I have one spinner that has a limitation of 1 to 51 - with a step of one.
(no problem)

I have another spinner that I would like to have a limitation of 1 to
(52-spinner 1).

I'm having problems with (52-spinner 1) limit. Data validation isn't
working - what do I need to do?

What I'm trying to do is allow the user to select which week will be their
start week (for graphing) and then be able to go - a selected number of weeks
after that (and I would like the spinners to be smart enough not to exceed 52
weeks) - Could one spinner do this? I realize I have just asked two
questions.


Brad

Spinners - minimum and maximum
 
When I do this I get an "Invalid property value" - error message

"Kevin B" wrote:

Make sure that the Controls tool bar is visible and click the design mode
button to activate design mode.

Right click on your spinner control and select properties and set the
Min/Max values for the spinner. Close the properties window and exit design
mode.
--
Kevin Backmann


"Brad" wrote:

I have one spinner that has a limitation of 1 to 51 - with a step of one.
(no problem)

I have another spinner that I would like to have a limitation of 1 to
(52-spinner 1).

I'm having problems with (52-spinner 1) limit. Data validation isn't
working - what do I need to do?

What I'm trying to do is allow the user to select which week will be their
start week (for graphing) and then be able to go - a selected number of weeks
after that (and I would like the spinners to be smart enough not to exceed 52
weeks) - Could one spinner do this? I realize I have just asked two
questions.



All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com