Hi,
I intend to get data (in short date format "13-Apr-2004") using txtbo
in a userform.
I tried this code:
Private Sub txtSheet_Change()
' Guarda el numero de Sheet a Importar
Dim Sh As Variant
Sh = Format(txtSheet.Value, dd - mmm - yyyy)
MsgBox "Sheet value=" & Sh
End Sub
but MsgBox apperars inmediatly after each digit.
How can I make nothing appens until I get all the 11 digits, and ho
making sure that data will be only in short date format (dd-mmm-yyyy
?
Thanks
--
Message posted from
http://www.ExcelForum.com