I am trying to figure out how to do this using VBA.

1) I have defined an array (10) called "Names"

2) In Cell B1 I a dropdown list from the "Names" array. (=Names)

3) In cell A1 the user can enter a number between 1 and 30.

4) If the user enters lets say the value 3. I am wanting cell B1 to change to the 3rd value in the "Names" array. I know you can use the INDEX(Names,3) or INDEX(Names,A1) but I do not want the formula to change in the dropdown list because if the user enters a number greater than 10, then they can manually select from the dropdown list. I have seen some post about List Index but do not quite understand it or even if it is valid here.

5) There might be a way to set the index under .Validation of a cell but I am not sure.

Any thoughts or if you need clarification let me know. I am new to VBA and trying to learn. Thanks for any feedback.