Melt info from 3 comboboxes into 1 box or bookmark   

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,

date: Wed, 19 Dec 2007 05:16:06 -0800   author:   Jazzcrime

Re: Melt info from 3 comboboxes into 1 box or bookmark   

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

date: Wed, 19 Dec 2007 14:35:06 +0100   author:   Helmut Weber

Re: Melt info from 3 comboboxes into 1 box or bookmark   

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.

On Dec 20, 12:16 am, Jazzcrime 
wrote:
> 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,

date: Sun, 23 Dec 2007 21:03:25 -0800 (PST)   author:   Tony Strazzeri