VBA code for Ctrl F1

[MarkCBB]

Hi there VBA pros,

I have a worksheet that contains alot of charts, so normally when I present these charts, I push ctrl F1 to increase the screen. is there some vba code that I can use to automate this?

 

[Domenic]

Try...

[font=Verdana]Application.SendKeys "^{F1}"
[/font]

However, unless this is going to be included as part of some other macro, it might be just as easy to use Ctrl+F1 instead.

 

[MarkCBB]

Hi There Domenic,

Thank you that is what I was looking for. doe the "^" stand for Ctrl? if not what does it mean in the syntacs?

 

[Domenic]

Hi There Domenic,

Hi Mark!

Thank you that is what I was looking for. doe the "^" stand for Ctrl? if not what does it mean in the syntacs?

Yes, it stands for Ctrl. For additional information, have a look at "SendKeys Statement" in the Developer Reference.