Advertisement
baykaone

Untitled

Nov 17th, 2020 (edited)
1,324
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Private Sub CommandButton1_Click()
  2.     Dim v_txt() As Variant, c As Variant
  3.     v_txt = Array(Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10, Q11, Q12)
  4.  
  5.     For Each c In v_txt
  6.         If Not IsNumeric(c) Then
  7.             c.Value = ""
  8.             c.BackColor = vbRed
  9.         Else
  10.             c.BackColor = vbWhite
  11.         End If
  12.     Next
  13. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement