Dependent Combobox

[cabete]

Hello every one.
I try to make a dependent combo box but are not be able to solve my difficulties.
That its not dependent.

 

[ranman256]

a form control combo box uses the cells on the spreadsheet and requires no programming.
and
the ActiveX combo box goes on a user form and MUST be programmed, usu during form load....

sub Form_Load()
  cboBox.add "USA"
  cboBox.add "England"
  cboBox.add "Canada"
end sub

 

[cabete]

That i know how to do.

My problem are another.See table bellow.
My combinations can be several

[TABLE="class: grid, width: 186"]
<tbody>[TR]
[TD][/TD]
[TD]Plastic Type[/TD]
[TD]Type[/TD]
[TD]Techenical Level[/TD]
[TD]Plates[/TD]
[/TR]
[TR]
[TD]15LL[/TD]
[TD]V0[/TD]
[TD]L[/TD]
[TD]D[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]15LL[/TD]
[TD]HB[/TD]
[TD]H[/TD]
[TD]D[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]25PW[/TD]
[TD]V0[/TD]
[TD]P[/TD]
[TD]E[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]25PW[/TD]
[TD]HB[/TD]
[TD]P[/TD]
[TD]H[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]25STD[/TD]
[TD]V0[/TD]
[TD]S[/TD]
[TD]C[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]25STD[/TD]
[TD]HB[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]40PW[/TD]
[TD]V0[/TD]
[TD]P[/TD]
[TD]D[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]40PW[/TD]
[TD]HB[/TD]
[TD]Y[/TD]
[TD]Q[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]40STD[/TD]
[TD]V0[/TD]
[TD]S[/TD]
[TD]C[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]40STD[/TD]
[TD]HB[/TD]
[TD]S[/TD]
[TD]H[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]65PW[/TD]
[TD]V0[/TD]
[TD]P[/TD]
[TD]D[/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]65PW[/TD]
[TD]HB[/TD]
[TD]P[/TD]
[TD]D[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]130PW[/TD]
[TD]V0[/TD]
[TD]R[/TD]
[TD]E[/TD]
[TD]U[/TD]
[/TR]
[TR]
[TD]130PW[/TD]
[TD]HB[/TD]
[TD]P[/TD]
[TD]U[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]130STD[/TD]
[TD]V0[/TD]
[TD]S[/TD]
[TD]F[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]130STD[/TD]
[TD]BH[/TD]
[TD]B[/TD]
[TD]Q[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]170STD[/TD]
[TD]V0[/TD]
[TD]S[/TD]
[TD]M[/TD]
[TD]T[/TD]
[/TR]
[TR]
[TD]170STD[/TD]
[TD]HB[/TD]
[TD]SF[/TD]
[TD]ER[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]


what i want its have the possibility to choose by line:
example:

130STD/V0/S/F/B
OR
130STD/HB/B/Q/-

 

[MickG]

Try this Example file:-
https://app.box.com/s/oemovj3wfx9k1fzz2hetapxzu5qqfi0u

 

[cabete]

Perfect.
Work 5*

 

[MickG]

You're welcome

 

[cabete]

Try to use but have a problem.
How can i take to some where (excel ceel) my choose on the combobox to print ?