Hi Alex

You could try using a combo box. See the Contextures site for full details -

http://www,contextures.com/xlDataVal10.html

"Alex Garner" wrote:

I may have hit a brick wall - none the less here is my issue.

My department works with a very detailed and busy rota on Excel and building
the rota on a weekly bases is using too much valuable departmental time. I
therefore would like to use a drop down list to select the entries thus
saving time. My problem is not with building the list it is viewving the list
due to the fact we work with the document at a 25% Zoom level and it seems
only possible to view the contents of the list at 100%.

Is there anyway that I will be able to view the list zoomed at 25%?