Excel dropdown list question

[Leslie67]

I'm trying to help a collegue with an Excel question and I haven't been able to find the answer anywhere.

The issue is this:

I have a list box on one column of cells in my spreadsheet. This was done through the data validation. In "Source" I have a list of 6 things. These are the only things I want showing up in these cells.

so far, so good.

What I WANT to happen is that when the "Stop" msgbox pops up saying "You have to pick from the list" is for the cell to be cleared so another value can be entered.

What IS happening is that when you click "Cancel" this happens; when you click "Retry" every time you try to click on the down arrow to select a new value, it gives you the error message "You have to pick from the list" right away.

Any suggestions?

 

[KenWright]

That's because they shouldn't be hitting 'retry'. Retry means try that data again and see if it will take it this time, not retry with another answer.

Doesn't help you do what you want I'm afraid, but that is why it does it.

Regards
Ken..............

 

[Leslie67]

Well, now, that would make sense...

Thanks Ken. I'll try and find a VB workaround.