So, because of the bugs with ActiveX controls, i.e. the resolution change causing zoom issues and font resizes, I am switching to a Form Control List Box. I have it working fine, but whenever I add an item to the ListBox, which requires me to change the listrange via VB, it is turning the font white. I have to go back reselect items to refresh the Listbox for it to go back to black font. It is very odd and I am not touching anything with font within so obviously another bug. I can select the items in the List box and they are correct, you just can't see the what the text is to select the correct item in the list.
Now I tried to switch to a dynamic Named range, but my issue is, if I remove the top item in the listbox, it corrupts the named range because it gives a #ref error because the first line was removed. Anyone have any suggestions? Thanks!