D delta Member Mar 25, 2018 #1 TextBox 1 To 10 store only numeric value by loop and any TextBox empty btween TextBox 11 To 15 than message box show enter any value how it is made by vba loop
TextBox 1 To 10 store only numeric value by loop and any TextBox empty btween TextBox 11 To 15 than message box show enter any value how it is made by vba loop
Hui Excel Ninja Staff member Mar 25, 2018 #2 Code: Dim i As Integer For i = 1 To 10 If IsNumeric(Controls("Textbox" & i).Value) Then 'textbox is numeric Else 'textbox is non-numeric End If Next i
Code: Dim i As Integer For i = 1 To 10 If IsNumeric(Controls("Textbox" & i).Value) Then 'textbox is numeric Else 'textbox is non-numeric End If Next i
