Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Control buttons
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Control buttons
Resolved · Low Priority · Version 2003
Reply Thu 12 Mar 2009, 16:39Delegate Simon said...
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)
For upcoming training course dates see: Pricing & availability
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
Reply Mon 20 Apr 2009, 13:25Delegate Simon said...
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
Mon 27 Apr 2009: Automatically marked as resolved.
|