Using a Marco to populate a Drop down box

February 7, 2011 at 22:33:40
Specs: Windows XP
I have a simple spread sheet in excel 2003 that uses several drop down boxes with a value of Yes or No or some other text value. I want to reset the values in the spread sheet to No through the use of a macro. The macro can reset all values of simple input but it ignores the drop down boxes. Any suggestions?

See More: Using a Marco to populate a Drop down box

Report •

February 8, 2011 at 06:26:58
re: "Any suggestions?"

Sure...I suggest that you describe the layout of your spreadhseet and post the code that you are using so we have a better idea of what you're working with.

Please read the How To referenced in my signature line before posting any data or code.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question