Hello All,
I have multiple textboxes in my userform. The reason I am just trying
to create a grids inside the userform(that is the only way I think
of:)). Here is my question, if I have too many texboxes with the names
are like ; textbox1,textbox2,textbox3...textbox34,textbox35 etc. my
code is something like below which I placed into keypress event for
userform.But I always get error for textbox name. Can you help me to
get me through
Thank you very much in advance

Private Sub UserForm_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If KeyAscii = 49 Then
GameNum = Sheet1.Range("game").Value 'that is the counter to key
press event
Label1.BackColor = &HFFC0C0
TextBox"& GameNum = "T" ' HERE I GET ERROR

End If
If KeyAscii = 50 Then
Label1.BackColor = &HFF&

End If
Sheet1.Range("game") = Sheet1.Range("game") + 1

End Sub