asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,284
- Office Version
- 2013
- Platform
- Windows
[TABLE="width: 184"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]column Z[/TD]
[TD]column AA[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A01[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]A02[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]A03[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]A04[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A05[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A06[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A07[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A08[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A09[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B01[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B02[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B03[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B04[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B05[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B06[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B07[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B08[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B09[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D5[/TD]
[/TR]
</tbody>[/TABLE]
Good Day,
Column Z datas are unique values which listed column AA values
Is it possble to load combo02 when selecting the related values from combo01
If ı select A from combo01 A1 to A10 will load to combo02 on userform.
Many thanks
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]column Z[/TD]
[TD]column AA[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A01[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]A02[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]A03[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]A04[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A05[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A06[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A07[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A08[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A09[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B01[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B02[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B03[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B04[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B05[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B06[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B07[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B08[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B09[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D5[/TD]
[/TR]
</tbody>[/TABLE]
Good Day,
Column Z datas are unique values which listed column AA values
Is it possble to load combo02 when selecting the related values from combo01
If ı select A from combo01 A1 to A10 will load to combo02 on userform.
Many thanks