Search string in VBA - How to ?

[101287]

Help...Guidance... Please
Problem:
String = 1234,4565,1034,5075
Would like to have code to search the above string and determine the numeric characters to the right of the string and then put then in a field and/or array. Search and store this fields until the string is complete read.

Can someone provide me an example on how to accomplish this? I don't have enough experience in VBA to address the above problem.

Guidance and help will be appreciated.

 

[SkipVought]

Hi,

dim a, s as string, i as integer
s = "1234,4565,1034,5075"
a = split(s, ",")
for i = 0 to ubound(a)
  msgbox a(i)
next

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[101287]

Thank you.