Hello,
How do to fill the range( B1:B5) with the value of namebox..
namebox selected based on the entered value is in cell a1
Namebox1= "Mylist"... Value 1,2,3,4,5
Namebox2= "Yourlist"... Value A,B,C,D,E

If we type Mylist in cell A1 Value in B1:B5 = 1,2,3,4,5...
thanks in advance