Accessing controls in excel using vbscript

[Guest]

I have an excel sheet which populates values based on a value selected in a
combobox. I am using a vbscript code to access this excel and generate an
html page.

My requirement is to generate seperate html page based on each value in the
excel combobox.

Using vbscript i need to write
I need to identify the combo list items.
I need to repopluate the excel for each combo values before generating the
html

How can i do this.
Thanks in advance.

 

[Tom Ogilvy]

With ActiveSheet.Combobox1
for i = 0 to .listcount - 1
v = .list(i)
' populate
next
End With