|I don't use WPS, so I can't set anything up to test.|
I'm still confused. You say "The box where the list is shows up, but it does nothing."
When I use a drop down list, the "box where the list is" doesn't show up until you click the drop down arrow. So what I am picturing is you moving your cursor over the drop down arrow, clicking it and having an empty list box show up.
If that's the case, I don't quite get the The cursor turns into an X part. When does that happen?
If the drop down arrow is working but the list box is empty, that would indicate to me that the range that the drop down is referring to is empty. Have you gone into Data Validation in Excel and checked to see what range should contain the list and then checked that range to see that it actually contains data?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.