Hey,

I am trying to refrence the name of an object on my userform... I have
setup a combobox with the values 1 - 10... the end result is when
someone selects a value it creates the the string of text "TextBox" &
X (X = number selected from combobox). I then have code that I want to
select that object based on the value of generated... any help is
greatly appreciated!!!

Private Sub ComboBox2_Change()
UserForm1.TextBox8.Value = "TextBox" & ComboBox2.Value
End Sub

Private Sub CommandButton14_Click()
Dim ZoneX As String
ZoneX = UserForm1.TextBox8.Value
ZoneX.SetFocus
End Sub

Why does this not work?