This was working one before, now it stoped. This is what I have
It is highlighting![]()
Please Login or Register to view this content.
What does this mean?![]()
Please Login or Register to view this content.
This was working one before, now it stoped. This is what I have
It is highlighting![]()
Please Login or Register to view this content.
What does this mean?![]()
Please Login or Register to view this content.
Last edited by LightHeart7; 01-16-2015 at 03:11 PM.
What is finderV.Value?
If the code unable to find finderV.Value then it can not loop through the range
![]()
Please Login or Register to view this content.
Hm, well the finderV.Value only can be a value in the B column. findV is a combo box pulling from values there. so the one i tried is Tester 1, which has two sets in there. Tester 1 - New York (Column C) & Tester 1 - California (Column C). Different rows. I was just trying to get it to list both NEw York and California in this finderC but i ran into this first.
If the code finds finderV.Value, it will loop through column C. If nothing is found, you will not get an error, rather the code jumps in to to end if line.
Although this also may mean nothing, but it will show you to check your data why there is no match found.
Perhaps i've done something strange then. Is it possible the problem is the Column is hidden?
Please attach the sample with the code. This help us to see what is going.
Oddly enough it started to work again after i tried to reset something, but thank you. But I will try and make up a sample for my other question on getting it to pull all items into the listbox
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks