Spin Box and Arrow Keys

[eashtm01]

Hello, is there a way to use the arrow keys on the keypad to control the information in a spin box? Also, is there a way to record the highest/ lowest number reached in the box? For instance, I want to be able to increase and decrease the value but I want to keep a a running collection of the highest and lowest numbers reached. Thanks for any help.

 

[6StringJazzer]

When I have a spin button that has focus, the up and and down arrow keys do change the values, doing nothing else special. What have you tried?

You need VBA to track the high- and low-water marks. It is advisable to track the actual values in cells so the information isn't lost if VBA resets, or the file closes and reopens.

 

[eashtm01]

Thanks for the reply. For the keys, I’m asking if I can use the up and down keys on the physical keypad to raise and lower the value in a cell. Hope this clarifies. Thanks.

 

[6StringJazzer]

That's exactly what happens when I create a spin button. I click the physical up and down arrows on the keyboard and the value goes up or down. The spin button simply needs to have focus.

 

[eashtm01]

Oh, I'll have to research that. I don't know anything about "Focus". Thanks.

 

[6StringJazzer]

A control has focus if it has been selected (clicked on). Then there is usually some sort of highlight or outline to indicate it has focus. If you have, for example, a worksheet with a textbox, you click on the textbox then you can start typing and the text goes into the textbox. If you have a spin button and click on the spin button, you can then use up and down arrows to continue to adjust the values.

Are you using a Forms spin button or an ActiveX spin button?

 

[6StringJazzer]

Here is an example. A cell is selected. I use the arrows, and it changes cells. I click on the spin button, and it now has focus and the keyboard arrows change the value.

 

[eashtm01]

I think just a forms spinbox

 

[6StringJazzer]

That would have been helpful to know. I used an ActiveX spin button, but a Forms spin button won't do this. It will be easier to meet both of your requirements if you use an ActiveX control.