Just need one line of code in the KeyPress event of the corresponding TextBox,
the result looks like this in VBA:
Private Sub myTextBox_KeyPress(KeyAscii As Integer)
KeyAscii = Asc(UCase(Chr(KeyAscii)))
End Sub
This way every letter of the alphabet the user presses is immediately...