EDIT: After more fiddling around I discovered that the problem may not have to do with the listbox at all. The named cell I used as Control Source has data validation with a drop-down list. I just tried selecting from one of those lists, and the same thing happens: the cell clears immediately. I’m trying to figure out why.

I have a request for help for a fresh code in Excel VBA.