ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Looping (https://www.excelbanter.com/excel-programming/309587-looping.html)

Louise[_4_]

Looping
 
Is there anyway of looping through each character in a
text box to compare the ascii number with something else?

Harald Staff

Looping
 
Hi

Sure

Private Sub CommandButton1_Click()
Dim S As String
Dim L As Long
S = Me.TextBox1.Text
For L = 1 To Len(S)
MsgBox Asc(Mid$(S, L, 1))
Next
End Sub


HTH. Best wishes Harald

"Louise" skrev i melding
...
Is there anyway of looping through each character in a
text box to compare the ascii number with something else?





All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com