ExcelChampion
Well-known Member
- Joined
- Aug 12, 2005
- Messages
- 976
Trying to get the list from a combobox in an online form. I'm doing this as a check to make sure what I need to be there is there. Then the macro will select what I need and move on. If not found in the list, then it will move on...
So I start thinking about it and I'm not quite sure how to do that in Forms. Does ListIndex get me there? Any help is appreciated.
I'm unable to give the site because you'd have to login with a password, but here's the code I have to Set the combobox:
Set PartNumOffr0EDrop = .Document.all.Item("PartNumOffr0EDrop")
myVal = PartNumOffr0EDrop.ListIndex
I need to know how to loop through the combobox and store the value of each member of the list to a variable or cell.
So I start thinking about it and I'm not quite sure how to do that in Forms. Does ListIndex get me there? Any help is appreciated.
I'm unable to give the site because you'd have to login with a password, but here's the code I have to Set the combobox:
Set PartNumOffr0EDrop = .Document.all.Item("PartNumOffr0EDrop")
myVal = PartNumOffr0EDrop.ListIndex
I need to know how to loop through the combobox and store the value of each member of the list to a variable or cell.