Mysterious Combo Box Problem
Posted by Paul E. on March 28, 2001 4:57 AM
I have a spreadsheet created by an associate, who is no longer with my company, which contains a combo box of the likes I have never seen before. He has managed to create a combo box object, which is actually the cell itself. I can select the cell and a drop down arrow appears, then I can make the desired selection. I can copy and paste this cell onto a different worksheet, and all of the functionality of the combo box is carried along with it.
The problem is that I don't think it was created with the Forms or Control toolbox. Whenever I go into design mode, I cannot right click on the drop-down arrow to view the properties. It is as if there is no real object involved, rather the cell has some how been modified to act like a combo box. I have looked in the VBA editor and can find nothing to help determine how this was created.
Any help would be greatly appreciated. Thanks