Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Colleen Burton   on Feb 12 In MS Office Category.

  
Question Answered By: Mona Wagner   on Feb 12

What do you thing about to use Split function?
You could try something like this:

'S <-- your form into a string
S = Replace(S, "<option>", "#")
S = Replace(S, "</option>", "")
S = Replace(S, "</select>", "")
S = Replace(S, vbNewLine, "")
S = Split(S, "#")

Then you will have an array where the values will be S(1) to S(Ubound(S)).

Share: 

 
 
Didn't find what you were looking for? Find more on Selecting from option list on webpage Or get search suggestion and latest updates.


Tagged: