I used data validation to create a drop-down list in cell b5 and named b5 "SelectRSM". Once the user selects a value from that list, I want to run macro "revise format". The macro itself runs fine when I request it, but I don't know how to get it to run automatically once the user selects a value from the drop down list. Can someone please head me in the right direction?