Loop through options in a select

[tackaman]

I have a subroutine that dynamically adds options to a select based on data entered into a number of text boxes. Everything works great except I need to change my sub to check the options that are in the select to see if it exists before adding the value. In other words, I don't want to duplicate the options in the select.

Can anyone provide sample code to loop through the options in a select and compare the values to the values in my text box?

 

[Geates]

I assume you are referring to a HTML select element?

<select id="names">
	<option value="Bill">Bill</option>
	<option value="Jack">Jack</option>
	<option value="Mary">Mary</option>
</select>

set objOptions = document.getElementById("names")
for each objOption in objOptions
   msgbox objOption.value
next

Of course, this will only work when executed by IE. Non-IE browsers do not support VBS. If you need it to be cross-browser compatable, I recommend using javascript - the code is essentially the same.

- Geates





"I hope I can chill and see the change - stop the bleed inside and feel again. Cut the chain of lies you've been feeding my veins; I've got nothing to say to you!"
-Infected Mushroom

"I do not offer answers, only considerations."
- Geates's Disclaimer

 

[SkipVought]

Or could it be a Select CASE structure?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]