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

Add this to the button code

Activesheet.Calculate

--
HTH

Bob Phillips

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

"Jay" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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
> > >
>