Hello, I have a slight problem when working with listview in excel 2016 user form.
So form A (with listview control) calls form B, then form B does something and we come back to form A.
At this point I need to requery my listview, and highlight previously selected row.
This is my code:
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
Code works fine, selects correct row, but listview doesn't reflect it. It looks like listview looses focus. Then I press tab few times, and when focus goes back to my listview, I see correct row highlighted.
It's interesting - when I set listview property HideSelection to False, it shows correct highlighted with grrey... not blue. So it confirms that selection code works.
I'm new to this, is this correct behaviour, how can I fix it?
Many thanks in advance