Simon has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Control buttons
How do you get a spinner button to scroll through a related drop list in the right direction. (The up arrow on the spinner scrolls down the drop list)
RE: Control buttons
Hi Simon. Are you trying to use one control to alter the behaviour of another? In the case of a drop down list box, the trick would be to capture the spinner button click action in a variable and use that value to trigger an alteration in the value of the listbox.text value. So, for example, a decrease in the spinner control value would cause the text in the listbox control to change to one less index value of the text value it currently is, thereby accurately scrolling through the values in the listbox. Knotty, but not impossible!
Hope this helps,
Anthony
RE: Control buttons
Thanks for this. Since winging this question at the Intro/Intermediate course I have established that the buttons in question are form buttons rather than the more versatile control buttons. It
RE: Control buttons
I hope it works out! Let me know how it goes, Simon.
Anthony
