I currently have named ranges with names that had to be adjusted so as to not conflict with a cell designation (AA2, AB2, AC2, AD2). Basically I had to rename my ranges to AAZ, ABZ, ACZ, ADZ so as to not conflict.

Is there a way via combo box to display AA2, AB2, AC2, AD2 but select range names AAZ, ABZ, ACZ, ADZ?

This may seem silly, but the users prefer the real names of AA2, AB2, AC2, AD2 and not the spoofed names of AAZ, ABZ, ACZ, ADZ.