Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
starting macro again
yesterday i asked how to start a macro on a condition of a cell and run it
once I recieved a reply with directions re Private Sub Worksheet_Calculate() etc. etc but am having trouble putting this in the right spot to make it work where exactly do these instructions go. the info goes into A7 manually any help appreciated Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
starting macro again
Post all of your code. Methinks you may want a worksheet_change event instead. In any event, event code goes in the WORKSHEET module. Right click sheet tabview code -- Don Guillett Microsoft MVP Excel SalesAid Software "Davidm" wrote in message ... yesterday i asked how to start a macro on a condition of a cell and run it once I recieved a reply with directions re Private Sub Worksheet_Calculate() etc. etc but am having trouble putting this in the right spot to make it work where exactly do these instructions go. the info goes into A7 manually any help appreciated Dave |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
starting macro again
Best to stick with the original post and make your replies there.
In my original post I gave you the choice of Calculate or Change events. Delete the Calculate line and remove the apostrophe from the Change event line. Right-click on the sheet tab and "View Code" Copy/paste the code I gave.................edit the two lines as above. Alt + q to return to the Excel window. Gord Dibben MS Excel MVP On Tue, 2 Jun 2009 15:45:01 -0700, Davidm wrote: yesterday i asked how to start a macro on a condition of a cell and run it once I recieved a reply with directions re Private Sub Worksheet_Calculate() etc. etc but am having trouble putting this in the right spot to make it work where exactly do these instructions go. the info goes into A7 manually any help appreciated Dave |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
starting macro again
Thanks, new to help.This has helped the situation and I am most grateful as I
will use this principal a lot in the future Regards Dave M "Gord Dibben" wrote: Best to stick with the original post and make your replies there. In my original post I gave you the choice of Calculate or Change events. Delete the Calculate line and remove the apostrophe from the Change event line. Right-click on the sheet tab and "View Code" Copy/paste the code I gave.................edit the two lines as above. Alt + q to return to the Excel window. Gord Dibben MS Excel MVP On Tue, 2 Jun 2009 15:45:01 -0700, Davidm wrote: yesterday i asked how to start a macro on a condition of a cell and run it once I recieved a reply with directions re Private Sub Worksheet_Calculate() etc. etc but am having trouble putting this in the right spot to make it work where exactly do these instructions go. the info goes into A7 manually any help appreciated Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Starting macro | Excel Discussion (Misc queries) | |||
Starting a macro execution where the cursor happens to be | Charts and Charting in Excel | |||
Starting A Macro | Excel Discussion (Misc queries) | |||
starting a macro at startup | Excel Discussion (Misc queries) | |||
Starting a macro with the IF function | Excel Worksheet Functions |