How a textbox_enter can change a SpinButton?

Hello,

I have a form with a listbox. It has some properties and, using a "textbox_change", a array and a button "finish", I can save values to that properties in a sheet.

To facilitate handling, without having to keep clicking all the time in the listbox, I created a SpinButton and it's working - I use spinbutton1_SpinUp and _SpinDown, ex:

Please Login or Register  to view this content.

However, I wish every time we type "enter", it goes to the next item on listbox. I tried, but I don't know how to call "_SpinDown" inside "Textbox1_enter()".

There must be a better way to solve it.

I have following idea:
- extract your code from _SpinDown, _SpinUp to outside procedure like Sub S_Down, Sub S_Up and then call those procedures in place of your code you need it.

Best Regards

1) could you attach your workbook ? It's quite difficult to help when we are blind
2) maybe you should tape textbox1.setfocus at the end of code in both procedures (Up, Down)

MaczaQ

Thanks. I had forgotten to put .setfocus both. But, it's working junst each twice; when I click for the first one, it changes the listbox, but does't put the focus on textbox.

please consider to attach your workbook with dummy data. It's realy hard to imagine how your whole code looks like and how your items (textbox, listbox etc.) are configured.

If it is possible please attach workbook, then I will try to help you more...

Best Regards

Here it is.