i need a statement that can evaluate whether or not a text box's value/text is a number or not? TIA
S Spencer Hutton Apr 22, 2004 #1 i need a statement that can evaluate whether or not a text box's value/text is a number or not? TIA
C Chip Pearson Apr 22, 2004 #2 Spencer, You can use the IsNumeric function to test whether a text string is numeric.E.g., If IsNumeric(Me.TextBox1.Text) = True Then ' is a number Else ' not a number End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Spencer, You can use the IsNumeric function to test whether a text string is numeric.E.g., If IsNumeric(Me.TextBox1.Text) = True Then ' is a number Else ' not a number End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
