need help

[Bilseka]

if i have a certain cell "cells(x,3)" contains text "steel conduits" or "pvc conduits" and i need another cell to make a validation function on a certain cells(rows),which contain different sizes of steel conduit as example, and this validation changed with change of the value of cells(x,3).

i need the code VB of this case.

Many thanks

 

[scottylad2]

Hopefully this simplified table will help. The items highlighted in yellow are your sizes for AUCables and Green for AVCables. select the column of yellow, and in the name box call them AUCables. Then do the same for the green and name that range AVCables. It's important there are no spaces in the names.

In cell I4 theres a list, the items in the list are AVCables,AUCables

In J4 theres another list, the item in that list is =Indirect(I4)

now select from the dropdown in I4 AUCable and you'll get all the sizes in a dropdown that are drawn from that named range and it will provide the dropdown for AVCables when you select that in I4

hope that helps

Excel Workbook
	F	G	H	I	J
3	AVCable	AUCable
4	5.25	1.5		AUCable	1.5
5	5.5	1.75
6	5.75	2
7	6	2.25
8	6.25	2.5
9	6.5	2.75
10	6.75	3
11	7	3.25
12	7.25	3.5
13	7.5	3.75
14	7.75	4
15	8	4.25
16	8.25	4.5
17	8.5	4.75
18	8.75	5
19	9	5.25
Sheet1

Excel Workbook
	F	G	H	I	J
3	AVCable	AUCable
4	5.25	1.5		AVCable	5.25
5	5.5	1.75
6	5.75	2
7	6	2.25
8	6.25	2.5
9	6.5	2.75
10	6.75	3
11	7	3.25
12	7.25	3.5
13	7.5	3.75
14	7.75	4
15	8	4.25
16	8.25	4.5
17	8.5	4.75
18	8.75	5
19	9	5.25
Sheet1

 

[Bilseka]

Hopefully this simplified table will help. The items highlighted in yellow are your sizes for AUCables and Green for AVCables. select the column of yellow, and in the name box call them AUCables. Then do the same for the green and name that range AVCables. It's important there are no spaces in the names.

In cell I4 theres a list, the items in the list are AVCables,AUCables

In J4 theres another list, the item in that list is =Indirect(I4)

now select from the dropdown in I4 AUCable and you'll get all the sizes in a dropdown that are drawn from that named range and it will provide the dropdown for AVCables when you select that in I4

hope that helps

Excel Workbook
	F	G	H	I	J
3	AVCable	AUCable
4	5.25	1.5		AUCable	1.5
5	5.5	1.75
6	5.75	2
7	6	2.25
8	6.25	2.5
9	6.5	2.75
10	6.75	3
11	7	3.25
12	7.25	3.5
13	7.5	3.75
14	7.75	4
15	8	4.25
16	8.25	4.5
17	8.5	4.75
18	8.75	5
19	9	5.25
Sheet1

Excel Workbook
	F	G	H	I	J
3	AVCable	AUCable
4	5.25	1.5		AVCable	5.25
5	5.5	1.75
6	5.75	2
7	6	2.25
8	6.25	2.5
9	6.5	2.75
10	6.75	3
11	7	3.25
12	7.25	3.5
13	7.5	3.75
14	7.75	4
15	8	4.25
16	8.25	4.5
17	8.5	4.75
18	8.75	5
19	9	5.25
Sheet1

thank you very much, i get it
​