Excel VBA Help
Share
The purpose of this page is to help those in need a more fashioned way than forums that are sometimes crowded with ads and very slow to get notifications.
I hope you all are doing great; what type of content are you willing to see?
Working with Arrays:
' define valid entries.
Dim code As Variant ' define the array
code = Array("A", "B", "C", "D", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "N/A", "NA", "NCR")
badCode = "0"
For i = 0 To 16 Step 1
If VBA.UCase(Me.txtNext.Value) = code(i) Then
badCode = "1" ' setting a value if condition is met
Exit For ' end if needed
End If
Next i
Click here to claim your Sponsored Listing.
Category
Website
Address
Indianapolis, IN
46224
