-
Solved: x dimensions array, combobox and loop...
hello,
I have a form with a series of comboboxes. I would like to pass the values of the comboboxes to an array. I'll check if there are duplicates in the database. for the input which are not duplicates I'll store the values in the database.
i would have 2 questions:
- is it a good strategy?
- how do i pass the values of the comboboxes into the array??
i have a problem with the "i" in the loop...
[vba]
Dim aSecurities()
ReDim aSecurities(1 To 6, 4)
For i = 1 To 6
aSecurities(i, 1) = Sectype & i & .value
aSecurities(i, 2) = Zone & i &. value
aSecurities(i, 3) = Valoren & i & .value
aSecurities(i, 4) = Ticker & i & .value
Next i
[/vba]
i've been trying using double quotes and another few tricks but it didnt work...
does anyone have an idea on how to deal with this please?
thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules