Scroll through ListBox using CommandButton

Is there any way that a CommandButton can be used to scroll a selection of ListBox items?

All are contained within a UserForm and the ListBox items are drawn from a dymanic list in a specified folder.

Hi mehmetcik,

Yes, When I click a button I would like to select the 1st entry in the ListBox and then with each subsequent click I would like the ListBox to select the next entry, and so on, in a loop.


Can that be achieved?

Thank you,

Andy

Hi there,

See if the attached workbook does what you need.

It uses the following code in the VBA CodeModule of the UserForm:

Please Login or Register  to view this content.

and the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Originally Posted by AndyE

Hi mehmetcik,

Yes, When I click a button I would like to select the 1st entry in the ListBox and then with each subsequent click I would like the ListBox to select the next entry, and so on, in a loop.

But what you're describing doesn't involve scrolling, it just looping the selection from one item to next item. Am I correct?

Thanks for the replies...ukuini, you are correct, lost in translation there I think, apologies...

I have had a look through the responses and I agree that a spinbutton or similar would likely be most suitable, but have the following observations if someone can assist?

I have attached an example workbook and some images within a folder structure replicating what I have.

The relevant filepath for the images will need to be replicated in the code.

I am encountering the following problems at the moment,

1 - Upon clicking the right spinbutton the first entry in Listbox1 is not selected, and,
If image#2 "sid" is selected in Listbox1, where "bird" is selected in Combobox1, then Combobox1 is changed to "cat", clicking the right spinbutton loads image#3 "spider", and so on...it's like the listbox value needs to be reset each time combobox1 is changed.

2 - If the last entry in Listbox1 is selected with the Combobox1 selections "cat" or "dog" and the Combobox1 selection is changed to the preceding value, i.e. "bird" or "cat" respectively, and the left spinbutton is clicked, all is well, however if the right spinbutton is clicked the following error is produced,

Run-time error '380':
Could not set the Selected property. Invalid property value.

Any ideas would be most welcome...

Thank you

*** Bump ***

Hi rorya

I was getting the same error message when I selected an entry in the ComboBox I couldn't understand why. Then I realised that in the version I am running one of the ComboBox entries didn't have any images attached which would populate the ListBox, hence the ListIndex would have to be -1 rather than 0, so it was crashing out at the line

Please Login or Register  to view this content.

.

I've fixed it by wrapping that section in an If command, checking that the ListBox is populated before continuing, I'm guessing that is the most convenient way to solve my particular problem?

Ha! Cool Thank you all for your help. I've got another question but that's for another post I think...

Hi again,

Many thanks for your private message and also for the Reputation increase - much appreciated!

You're welcome - glad to hear that everything seems to be working correctly now.

Best regards,

Greg M