Thread: read one char
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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!