command button to do F9 function
 

Hi,

i want a F9 function to be done by command button when i click on it

i have 10 worksheet all of them have formulas , when i enter data on
first sheet i will click on Command button and it should calculate all
the formulas on all sheet i.e F9 function

can it be done using Macro ? please send methe code for the same.

thank you in advance

regards
Jay

command button to do F9 function
 

Add this to the button code

Activesheet.Calculate

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jay" wrote in message
ups.com...
Hi,

i want a F9 function to be done by command button when i click on it

i have 10 worksheet all of them have formulas , when i enter data on
first sheet i will click on Command button and it should calculate all
the formulas on all sheet i.e F9 function

can it be done using Macro ? please send methe code for the same.

thank you in advance

regards
Jay

command button to do F9 function
 

Bob,

Thank you for ur reply ?

where shall i put this code ? i m new to VBA ...

does it calculate all the worksheet formula

regards
Jay
Bob Phillips wrote:
Add this to the button code

Activesheet.Calculate

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jay" wrote in message
ups.com...
Hi,

i want a F9 function to be done by command button when i click on it

i have 10 worksheet all of them have formulas , when i enter data on
first sheet i will click on Command button and it should calculate all
the formulas on all sheet i.e F9 function

can it be done using Macro ? please send methe code for the same.

thank you in advance

regards
Jay

command button to do F9 function
 

Create a macro in a standard code module, with that code. When you create a
button, add the code to it.

See http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jay" wrote in message
oups.com...
Bob,

Thank you for ur reply ?

where shall i put this code ? i m new to VBA ...

does it calculate all the worksheet formula

regards
Jay
Bob Phillips wrote:
Add this to the button code

Activesheet.Calculate

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jay" wrote in message
ups.com...
Hi,

i want a F9 function to be done by command button when i click on it

i have 10 worksheet all of them have formulas , when i enter data on
first sheet i will click on Command button and it should calculate all
the formulas on all sheet i.e F9 function

can it be done using Macro ? please send methe code for the same.

thank you in advance

regards
Jay