Melt info from 3 comboboxes into 1 box or bookmark

[Jazzcrime]

hi people!

I currently breaking my head over an issue, i could use some help!

- i have 3 comboboxes: combobox1 (list of country's), combobox2 (list of
company's), combobox3 (list of city's)

every possible combination of value's from comboboxes have a code.

my question:

what is the easiest way to get this done? their are 5 value's in combobox1,
3 value's in combobox2 and 6 value's in combobox3.

combobox1.value & combobox2.value & combobox3.value = combobox4.value

the thing is, combobox4.value = has not to be the value's from combobox
1/2/3 but a code that is decided by the value of combobox1/2/3. this value is
a code that is decided already by my boss, so it cannot be random.

for example:
Combobox1 = UK
Combobox2 = Microsoft
Combobox3 = Londen
Combobox4 = 12345

or

Combobox1 = UK
Combobox2 = Microsoft
Combobox3 = Manchester
Combobox4 = 55554

my english is not very good, i hope u understand my problem!

kind regards,

 

[Helmut Weber]

Hi Jazzcrime,

hmm...

every possible combination of value's from comboboxes have a code.
this value is a code that is decided already by my boss

if there is no algorithm, which returns the code,
then you need an enumeration...



--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP

 

[Tony Strazzeri]

Hi Jazzcrime,

Presumable each value in each combobox has a code. Where is that
stored?

You could store the code in a second column of the combobox and then
extract that column to generate the value for combobox 4.

But why have a combobox4 at all if the value for is calculated based
on the other items?
There will only be one value for each combination of the other
comboboxes

Cheers
TonyS.