ExcelBanter - getting data from an array of varying amounts of comboboxes

On Jun 20, 1:32 pm, "
wrote:
I was unable to answer this query using the power of google...
therefore I present my dilemma.
---the stuff I've got working---
step 1. user enters an ID into a cell. if this ID is numeric, then in
3 adjacent cells, combo boxes appear with up to 20 different options
in each.

step 2. user selects various options from these combo boxes.

step 3. users then enters more IDs into cells. step 1&2 repeat until
the user has completed his adjustments.

----

step 4. user clicks button (get data) and initiates the following
(currently theoretical) procedure

****E I PRESSED TAB/enter and sent by mistake. sorry. continueing
onwards:

at step 4 the following should occu

for each ID
1. the ID is assigned to a variable (ID) (done)

2. each selection from the combo box is assigned to a variable
- the probem is that I have varying numbers of combo boxes; usually
one can evaluate each combo box on it's own; yet with a varying amount
of boxes, and a varying degree of placement (not all combo boxes get
assigned to the same column all the time), I haven't been able to
quite figure out how to control them. I'm toying with the idea of
taking whatever text is selected in the combobox and copying it to the
cell beneath, but once again, i don't know quite how to do this when
combobox indexes are not constant/constant mulitples of each other.
(say the third combobox is always in column k, therefore multiples of
3 are always in column K)

3. the macro then takes this information and searches a database for
matching entries. (fairly straightforward- so I don't need this bit
answered)

I'm not sure that code is needed, but if necessary, I can post what I
have.

THANK YOU!
laryssa