need vba to datavalidation throgh combobox1-5,

If you can't figure out how a formula works, try stepping through it using "Evaluate Formula" in the Formula Auditing menu item in the tools menu!

If you want to see where your code went wrong, try stepping through it by clicking in the code and pressing F8 and watch as the magic happens!


If you are happy with any of the results, please add to the contributor's reputation by clicking the star icon.