populate A2 with choice from array

[Grahamfeeley]

I would like to be able to populate A2 with a choice from a list or an array
like this

Please Login or Register  to view this content.

Probable use a var with inputbox like 1 for "Turffontein", 2 for "Hastings" etc etc
I am not sure how to get around this

Any help will be much appreciated
Regards
Graham

[AlphaFrog]

Try something like this. Note: an input box can only display five line of text. If your list is longer, consider making a UserForm with a Listbox.

Please Login or Register  to view this content.

[Grahamfeeley]

Thank you AlphaFrog for your effort, this works great
Much Appreciated
Graham