Quick question which hopefully someone can answer.
Material is a single cell with data validation. When the code executes and selects SelectMaterial, is there code to automatically show the dropdown list?
Edit: XL-Dennis confirmed my suspicions since I couldn't find any properties, methods, or events. He says we can't control data validation and suggested an Active-X control but that's not viable. I guess I could use a UserForm instead. Oh well! The more we can do, the more we want to do. :?