List Box Control (Up & Down arrows)

[IfButOnly]

I have a list box getting values from a value list. I have reduced the size of the list box to one line and use the Up & Down buttons (scroll bars) to move thru to the value I want.

What I want to do is update a calculated field as I scroll thru the values - how do I trap that I have pressed either of the buttons on the list box?

 

[Fizzio]

Your calculated field (if it refers directly to the list box) will update automatically. This will only happen if you actually change the value in the listbox. Scrolling down the list will show a value but until you select the value using the arrow keys (keyboard) or mouse click, the new value will not be selected and hence the calculation will not change. If you only want to show one value, why not use a combo as the value shown in the combo is the one selected. In your case, the value shown may not be the value selected.

 

[IfButOnly]

Thanks Fizzio - I assumed this was the case but hopeful of some workaround. Main reason for not using the combo box was just for screen ergonomics & a simple manner of displaying 'what if' type calculations without too much key entry.

I am currently using a couple of small control buttons, beside the field to do the job - but it doesn't look as nice as the inbuilt buttons.