This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button
Solved
Nested For Loops to Look at 2 ListBoxs in VBA UserForm
Posted on 2012-12-31
Hi All
Happy New Year. I'm attempting to compare items from one listbox with those in another listbox (both on the same userform).
I appear to be using the wrong approach because ListBoxA stops passing values when I introduce a nested ForLoop to look at ListBoxB. Code as follows:
As soon as I uncomment the inner For-Next the MsgBox will not display AItem
This is most alarming!
Cheers, S
Happy New Year. I'm attempting to compare items from one listbox with those in another listbox (both on the same userform).
I appear to be using the wrong approach because ListBoxA stops passing values when I introduce a nested ForLoop to look at ListBoxB. Code as follows:
For i = 0 To myForm.ListBoxA.ListCount - 1
myForm.ListBoxA.ListIndex = i
AItem = myForm.ListBoxA.Value
MsgBox ("List A: " & AItem)
' For j = 0 To myForm.ListBoxB.ListCount - 1
' Next j
Next i
As soon as I uncomment the inner For-Next the MsgBox will not display AItem
This is most alarming!
Cheers, S
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
2
2
9 Comments
Active 2 days ago
You need to use ItemData property.
For i = 0 To myForm.ListBoxA.ListCount - 1
AItem = myForm.ListBoxA.Itemdata(i)
MsgBox ("List A: " & AItem)
' For j = 0 To myForm.ListBoxB.ListCount - 1
' Next j
Next i
Thanks for your reply.... I get an error:
Compile Error:
Method or data member not found
I tried changing the i to a 1 for testing purposes (there are 3 items in my list so this should have worked... I have not uncommented the other code.
Cheers,
Compile Error:
Method or data member not found
I tried changing the i to a 1 for testing purposes (there are 3 items in my list so this should have worked... I have not uncommented the other code.
Cheers,
Active 2 days ago
Sorry, I just noticed you're doing this in MS Word. I assumed you were in Access. Can you upload a copy of this document? Just remove any private information first.
Will clean for upload. The other thing I noticed is that if I click in the listbox before running my macro it works perfectly. BUT if I don't click (which would be easily anticipated for this application) it does not work... is there a way to give focus to the list - that might help too...
BTW sorry for reply lag... for some reason my EE emails are not popping up :-(
Thanks
BTW sorry for reply lag... for some reason my EE emails are not popping up :-(
Thanks
Active today
Steve,
There seems to be a bug, but it isn't anything to do with the inner loop, at least on my system, where it happens on alternate runs. It fails; but stop VB and restart, and then it works.
IrogSinta has the right idea, but you need to use the List property
There seems to be a bug, but it isn't anything to do with the inner loop, at least on my system, where it happens on alternate runs. It fails; but stop VB and restart, and then it works.
IrogSinta has the right idea, but you need to use the List property
Private Sub CommandButton1_Click()
Dim i As Integer
Dim j As Integer
Dim AItem As String
For i = 0 To myForm.ListBoxA.ListCount - 1
AItem = myForm.ListBoxA.List(i)
MsgBox ("List A: " & AItem)
'For j = 0 To myForm.ListBoxB.ListCount - 1
'Next j
Next i
End Sub
Active today
That's good news.
Incidentally, you could still use the .Value property by 'clicking' the listbox programatically.
Incidentally, you could still use the .Value property by 'clicking' the listbox programatically.
Private Sub CommandButton1_Click()
Dim i As Integer
Dim j As Integer
Dim AItem As String
For i = 0 To myForm.ListBoxA.ListCount - 1
myForm.ListBoxA.ListIndex = i
myForm.ListBoxA.SetFocus
AItem = myForm.ListBoxA.Value
MsgBox ("List A: " & AItem)
'For j = 0 To myForm.ListBoxB.ListCount - 1
'Next j
Next i
End Sub
Featured Post
Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you work with Word a lot, you probably use styles. If you use styles a lot, you've probably balled your fist more often than not when working with the ribbon.
In Word 2007/2010, one of the things that I find missing when using styles is a quic…
Preface:
When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses.
Navigate to the “Start Mail Merge” button in the Mailings tab:
Follow the step-by-step process until asked to find the address doc…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents.
Type out your initial …
Suggested Courses
Course of the Month8 days, 11 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.