Edit multi selected Listbox items in userform

Question

Edit multi selected Listbox items in userform

Anonymous

Hi. Still new at Coding in VBA...

I want to select multiple items from a ListBox and then edit them in an UserForm one by one through a loop, but on every second run through the For Loop, I get the next run-time error:

In the Userform with the ListBox I have the following Code after selecting a few rows:

In the UserForm "Form_DetailEdit" the TextBoxes get populated correctly. By just clicking the Close Button, the next Code is running:

When running through the "For Coll_Row"-Loop the second time is stops at

" ThisForm.TheCurrentRow = List_Row" with the above mentioned error.

Could anyone explain to what I'm doing wrong and how to fix this.

Greatly Apreciated

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

Hello,

Welcome to Microsoft Community and appreciate your time taken for sharing detailed information. I could share with you some of my thoughts on this issue.

Your question involves VBA. In order to get a timely response to your questions, our recommendation is that you can submit your questions to the IT Pro forum.

Developer tools, technical documentation and coding examples | Microsoft Docs

Feel free to post back if you need any further assistance.

Best Regard,

Kevin | Microsoft Community Support Specialist

*Beware of scammers posting fake support numbers here."

*Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

*If your problem is not solved, you could reply to the post again and we would continue to provide technical support for you.

Share via

Edit multi selected Listbox items in userform

1 answer