VBA code to read the value of a RANGE NAME and use it as Validation

[maleodillet]

Hi Gurus,

I have a requirement where I need to add a macros button to execute a VBA code that will read the string value from a "cell" that contains a "data validation list" with three options ( No Revision, Revision 1, Revision 2) and based on the option selected for that cell from the drop-down (saved as data range "Revision_range") allow for different actions, such as;

- if the drop-down selection is "No Revision" display text "No revision selected" and exit sub
- if the drop-down selection is "Revision 1" or "Revision 2" display text "Saving to Selected Revision version" and then run my SAVE method.

Lastly display the text "Revisions Created"

I hope ya'll can assist me here, thanks in advance