Hi,
I am struggling with a really weird and annoying error. I have this line of code in a macro:
EndRangeClearlistbox = Sheets("Utilization Tab").UtilSelectServiceListBox.ListCount - 1
This line is throwing the run time error 57121 - Application defined or object defined error.
Here is the weird/annoying part - Only certain computers are giving this error. This code works absolutely fine on my laptop but is giving the run time error on a colleague's computer.
"UtilSelectServiceListBox" is an activex listbox control. I have to know the number of items in this listbox for the program to work further so I am open to any/all suggestions that will fix this issue. It is extremely annoying that this is an issue on only certain machines. I also searched for alternatives to the "ListCount" property and couldn't find any that solved my issue.
Bookmarks