Cmd Button to populate all drop down list on a worksheet as "Yes"

MaczaQ has the right idea, let's hope that it's as simple a task at that, otherwise you will have to include each individual range that is affected

Originally Posted by scott.s.fower

MaczaQ has the right idea, let's hope that it's as simple a task at that, otherwise you will have to include each individual range that is affected

If the OP is using validation lists (sounds like he's using drop down lists though) that aren't in sequential order ie are not in range A1:A30, an easy option would be to select all of those cells on the worksheet with your mouse and name the range. Then you should be able to just reference that named range in the VBA code. Would be a lot less tedious than referencing each cell individually for what's it's worth

VBA FTW,

that's a good idea, unless they are all over the sheet, i think the macro i wrote would be the best method to avoid having to find all the cells with validation