One of the most frustrating issues with developing in Excel are all the quirks that seem to pop up. I’ve wasted almost 2 or 3 hours today dealing with this issue: for some reason, way unknown to me, Excel will delete controls that I have drawn and placed onto worksheets. (I haven’t noticed this behavior happen with userforms.)

This usually happens when I have copy and pasted controls. That seems to be the issue - the copy and paste. So if you notice that your controls keep disappearing - don’t keep copying them to get them back, just draw them again. Perhaps the original control corrupts eventually, I don’t know, just don’t encourage this type of behavior.