String Manupulation

  • Thread starter Thread starter Mili
  • Start date Start date
M

Mili

Hi,

I am trying to display the character in a string one
by one in a message box. I am not getting how to do it.

I am using Microsoft Office 2000. (using Macro)

Thanks

Regards

Mili
 
Mili,

I'm not sure exactly what you want, but maybe the following will be of use.

Dim N As Integer
Dim S As String
S = "test"
For N = 1 To Len(S)
MsgBox Mid(S, N, 1)
Next N


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Hi,

How to get the charcode of the character I am displaying.

for example we have Chr$(charcode)
in the same way can we display charCode if we know the
character ??

Thnaks

Regards

Mili.
 
Hi,

How to get the charcode of the character I am displaying.

for example we have Chr$(charcode)
in the same way can we display charCode if we know the
character ??

Thnaks

Regards

Mili.
 
Mili,

You can use the Asc function to return the character code. For example,

Asc(Mid(S, N, 1))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top