Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign a function to a Command Button | Excel Worksheet Functions | |||
Assign Function to a Command Button | Excel Discussion (Misc queries) | |||
Command button to run calculation function | Excel Programming | |||
using command button instead of edit function | Excel Programming | |||
Command Button Function - Macro | Excel Programming |