sendkeys statement
 

I am very new to VBA.

I want the user to be able to click a command button to
execute what could be done by manually entering "ALT F9".

Any help would be great,
Thanks
Matt M

sendkeys statement
 

Hi
have a look at the VBA help for Sendkeys:
SendKeys "%{F9}", True

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt M" schrieb im Newsbeitrag
...
I am very new to VBA.

I want the user to be able to click a command button to
execute what could be done by manually entering "ALT F9".

Any help would be great,
Thanks
Matt M

sendkeys statement
 

Hey Frank,
I am not exactly sure how to enter this into VBA and what
code to surround it with. Am I a lost cause?
Thanks,
Matt

-----Original Message-----
Hi
have a look at the VBA help for Sendkeys:
SendKeys "%{F9}", True

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt M" schrieb
im Newsbeitrag
...
I am very new to VBA.

I want the user to be able to click a command button to
execute what could be done by manually entering "ALT
F9".

Any help would be great,
Thanks
Matt M

.

sendkeys statement
 

Hi Matt
if you only want the application to re-calculate you may use the
following macro

sub calc()
application.calculate
end sub

and assign this to a button. Also have a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm
for getting started with macros

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt M" schrieb im Newsbeitrag
...
Hey Frank,
I am not exactly sure how to enter this into VBA and what
code to surround it with. Am I a lost cause?
Thanks,
Matt

-----Original Message-----
Hi
have a look at the VBA help for Sendkeys:
SendKeys "%{F9}", True

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt M" schrieb
im Newsbeitrag
...
I am very new to VBA.

I want the user to be able to click a command button to
execute what could be done by manually entering "ALT
F9".

Any help would be great,
Thanks
Matt M

.