Very simple question:
Given a userform with ComboBoxHorizontalAlign populated with the values "Left", "Right", and "Center", and a current Value of "Left"

With wsTarget.UsedRange
    'Set horizontal alignment
    .HorizontalAlignment = xlLeft 'This works
    .HorizontalAlignment = "xl" & ComboBoxHorizontalAlign.Value 'This doesn't work.  I want it to.
End With
What am I missing?