ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   read one char (https://www.excelbanter.com/excel-programming/374485-read-one-char.html)

Arne Hegefors

read one char
 
i want to read a string one char at the time. how do i do this? pls help!

Tom Ogilvy

read one char
 
Dim s as String, sChr as String, i as Long
s = "ABCD"
for i = 1 to len(s)
sChr = Mid(s,i,1)
msgbox i & ": " & sChr
next

--
Regards,
Tom Ogilvy


"Arne Hegefors" wrote:

i want to read a string one char at the time. how do i do this? pls help!



All times are GMT +1. The time now is 11:57 AM.

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