Work around for cell name & range name conflicts?

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.

That is no better a solution than what I did. The fields AA2, AB2, AC2, AD2 are not going to be used in any part of this workbook, and my users want to use those names to select named ranges.

With a lot of trial and error, I was able to find relatively simple solution using combo box parameters and creating a 2 column list for the combo box.

The Combo Box List (Sheet2)

AA2 AAZ
AB2 ABZ
AC2 ACZ
AD2 ADZ

Under combo box properties set

Bound Column = 2
Column Count = 2
Column Heads = False
ColumnWidths = 1 pt;0 pt
RowSource = Sheet2!A1:B4

No vba required.

Basically the combo box will list items in the first Column, but the named ranges identified in the second column are used and passed for further processing.

My question now, is if the user wants to enter the data in a text box, is this name change possible as it was in a combo box?

My solution for text box was to use If Then ElseIf

'-Textbox txtQTR3 exceptions to avoid cell name conflict
Private Sub txtQTR3_AfterUpdate()
    If txtQTR3.Text = "AA2" Then
        txtQTR3.Text = "AAZ"
        ElseIf txtQTR3.Text = "AB2" Then
        txtQTR3.Text = "ABZ"
        ElseIf txtQTR3.Text = "AC2" Then
        txtQTR3.Text = "ACZ"
        ElseIf txtQTR3.Text = "AD2" Then
        txtQTR3.Text = "ADZ"
    End If

End Sub