increase zoom when a particular cell is selected

[tlacloche]

hello,

i have a drop box (data validation) which is impossible to see with the current sheet's 60% zoom.
i was thinking when the drop down menu is clicked, it would be a nice idea for the zoom to automatically change to 110% so you can see the list easily.

then when you click away after youve selected ypur option, the zoom returns to 60%.

does anyone know how to write this in vba

thanks

[zbor]

Try something like this:

Please Login or Register  to view this content.

Edit: You can use specific range instead of whole column. Depending on your data.

[davesexcel]

put this in the worksheet module.

Please Login or Register  to view this content.

[tlacloche]

where in the code do i put in the cell with the data validation

[zbor]

Right click on your sheet name -> View Code and post either mine or davesexcel solution

[tlacloche]

i used daveexcels. works perfectly. thanks.

is it possible to centre the cell so its the focal point of the screen

[Greg M]

Hi there,

The following code will increase the Zoom value to 110 whenever the "ZoomCell" is selected. When another cell is selected the Zoom value will be reset to whatever value it had before the "ZoomCell" was selected.

The code should be inserted in the VBA CodeModule for the worksheet(s) in which you wish to provide an automatic zoom facility.

Please Login or Register  to view this content.

The above approach has the advantage of not having to hard-code (and subsequently change if required!) a value for the lower Zoom level.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[justigger]

The post from Zbor has helped me quite a bit!
One question though, I have two different columns that I would like to zoom in on when selected. How would that coding look? I can't quite get it to work. The single column is great though, just can't get the second one to zoom.

[justigger]

The post from Zbor has helped me quite a bit!
One question though, I have two different columns that I would like to zoom in on when selected. How would that coding look? I can't quite get it to work. The single column is great though, just can't get the second one to zoom.

[zbor]

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.