Click on Cell and Excel Zooms in

Hi,

I guess the question is as is in the title. Is there any VBA Code where I can click a cell or area on the worksheet and Excel will zoom to that area?

Regards,
David

Winon,

Thanks for the reply. I basically want to be able to click a cell, or more importantly a chart object which when clicked (or double clicked) will, lets say for example, be zoomed to full screen. I have seen this done before but can't remember unfortunately the method put forward. Do you have any suggestions?

Thanks.

JosephP,

Thanks for the reply.

Unfortunately I do need to click the graph to get information regarding what values the lines correspond to and the axes. Would there be a method available that would only increase the chart size if double clicked and double clicking again would return to the original zoom?

Winon I appreciate your help too

Regards,
David

Winon,

Thanks for the reply. I looked through the link you sent and unfortunately it's not exactly what I am looking for. I did however find the below code:

Option Explicit

Dim objChartClass() As clsChart

Sub SetChartObjects(wks As Worksheet)
    Dim intChartCount   As Integer
    Dim cht             As ChartObject
    
    intChartCount = 0
    For Each cht In wks.ChartObjects
        ReDim Preserve objChartClass(intChartCount)
        Set objChartClass(intChartCount) = New clsChart
        Set objChartClass(intChartCount).objChart = cht.Chart
        intChartCount = intChartCount + 1
    Next cht
    
    Set cht = Nothing
End Sub

I unfortunately do not understand the code and as a result am finding it difficult to implement into my workbook. Do you have any suggestions or do you understand the method in place. I really appreciate your help. Thanks a bunch.

Regards,
David

Winon,

I wanted to see if you noticed an issue with the coding because when I add it to my workbook it does work, as in a click a graph and it enlarges to full screen, click again and it minimises, but then I receive an error report and Excel crashes Not sure why and thought yo might be able to shed some light.

I am sorry, probably should have mentioned this in my previous post.

Regards,
David

Winon,

I do not know where you got the information from but I only have Excel 2007 installed on my computer so its odd that you say that? However I understand it may work on your computer but the workbook I am using that set of code in (which is filled with 100's of lines of macro code (and for work reasons I am not allowed to upload)) seems to crash when I use the chart zooming. It may just be down to the shear amount of data in the workbook and unfortunately an error code is not issued therefore I cannot reference the issue online.

I understand having the workbook available to you you would probably sort it out very quickly but sadly I am not in a position to do so

Regards,
David