MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by mseyf on March 28, 2001 5:25 AM

Paul:

highlight the cell in question, then on the menu bar select Data > Validation. The detail should be there.

HTH

Mark

Posted by Aladin Akyurek on March 28, 2001 6:22 AM

Mark: Remember the thread involving Dustin's INDIRECT problem. He sent me his workbook. Well, he had also something similar, a dropdown box/list. I couldn't determine how it was made (he didn't answer me yet to explain it). You can't even select the cell in which it supposed to reside. Moreover, it was the culprit in his case: that is, the selection made thru the box was useless for the formula that needed the selected value couldn't read it. I had to build an ordinary one via Data|Validation for his case.

Paul's can be another such case, but I hope not.

Aladin

Posted by Paul E, on March 28, 2001 8:10 AM


THANKS A MILLION!! I didn't even know that function existed. You guys just made my life much easier.

Thanks again!