Greetings, I am posting this thread as a last resort after days of searching google and trying different approaches on my own.
The goal is to change the Height property of a ListBox at runtime so that it is large enough to show only the populated rows (which can be few or many depending on previous options).
On Windows, I used a break on a userform, used the immediate window to find the Height property of said ListBox, then counted the visible rows. After quick division I wrote a piece of code that multiplies the ListBox.ListCount by that number and poof, it works. The issue now, is that this has to work on both Windows AND Mac. The same process on the Mac did NOT WORK. I can't seem to figure out where the disconnect is/what is different about the Mac ListBox. Any advice or suggestions?
The goal is to change the Height property of a ListBox at runtime so that it is large enough to show only the populated rows (which can be few or many depending on previous options).
On Windows, I used a break on a userform, used the immediate window to find the Height property of said ListBox, then counted the visible rows. After quick division I wrote a piece of code that multiplies the ListBox.ListCount by that number and poof, it works. The issue now, is that this has to work on both Windows AND Mac. The same process on the Mac did NOT WORK. I can't seem to figure out where the disconnect is/what is different about the Mac ListBox. Any advice or suggestions?