VBA Excel 2010 verify userform textbox input as text
Posted on 2013-01-16
Learning VBA for Excel. I'm using Excel 2010.
I have a userform with an input text field named "TextName".
When the user clicks a button, the content of the textbox is added to a new row at the bottom of a worksheet column.
How do I force the content to be text only?
Here's what I'm trying, but it does not work:
If Not Application.Workbooks.IsText(TextName.Text) Then
MsgBox "Please enter text only."