Sorry, can I ask you one last question.

I have entered a msgbox at the start of the procedure, at which poin
the user is asked to enter the name of the city they wish to look at
eg: New York.
I have got this working, and when I enter the correct city name in th
box it outputs only data relating to that city.

However I want it to full proof. Is there a way to allow the user t
pick from all available cities in the msgbox ?!

THanks a million.

Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=26382