Executing a Macro after a cell changes due to a ''new" calculation

Goodday,

I tried to use the worksheet change functions, yet they only seem to act
when you actively enter into a certain cell.

However i need to call a certain macro when the output in a certain cell
changes due to the change in the specific if function. Therefore without
user intervention.

Is there any way to do this?

Kind regards,

Ivo Geijsen
i.geijsen@chello.nl


0
Tornados
12/23/2003 6:29:24 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
370 Views

Similar Articles

[PageSpeed] 31

You have one guess at your other post:

Take a look at the worksheet_calculate event.

Tornados wrote:
> 
> Goodday,
> 
> I tried to use the worksheet change functions, yet they only seem to act
> when you actively enter into a certain cell.
> 
> However i need to call a certain macro when the output in a certain cell
> changes due to the change in the specific if function. Therefore without
> user intervention.
> 
> Is there any way to do this?
> 
> Kind regards,
> 
> Ivo Geijsen
> i.geijsen@chello.nl

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
12/23/2003 6:48:12 PM
Reply:

Similar Artilces:

VBA Opening worksheet, name changes
I have a VBA code - that opens a worksheet, then gets data. The problem is that the worksheet name can change, then it won't open. Is there anyway to save the worksheet name as some variable, that can reference the worksheet name/location + will automatically update? Thanks Use the codename not the Excel name. This is usually the same, Sheet1, Sheet2, etc, but it doesn't change if the user changes the Excel name. You use it like Sheet1.Range("A1") instead of Worksheets("Sheet1").Range("A1") -- HTH Bob Phillips "Jeff" <Jeff@di...

Publishing Form Changes via Web Access
Hi I access CRM 1.2 via the web. In the past I have made changes to forms and they have appeared when I save and close. This no longer happens. Our IT support have restarted IIS but to no avail. Can anyone help please? Thanks Adam Hello AdamG, Have you published your changes before restarting IIS? In 1.2, only altering views and picklists showed up dynamically. Any form changes must be pulbished in the Deployment Mananger first. Kind Regards Eddie Fourie MBS Specialist A> Hi A> A> I access CRM 1.2 via the web. In the past I have made changes to A> forms and they have...

DOS Function in a Macro?
Can I create an Access macro that runs a DOS command. The command is "DIR /B >filelist.txt" Or better yet is there a way to bring up a dialog box and select the directory I want to run that DOS command on? Thanks in advance Perhaps there is a better solution to my dilema. I'd like to have a function that queries the contents of a selected folder and writes that data to a table. For example: c:\files\file1.txt c:\files\file2.txt c:\files\file3.txt c:\files\file4.tif c:\files\file5.jpg This gives me the ability to inventory data that I receive. ...

macro run-time dialog box causing integration manager problem in GP9.0
I'm using AutoDim and windows scheduler to run integrations in integration manager. In GP7.5 it all worked fine but now that I've upgraded to GP9 there is a macro run-time dailog box that's causing problems. I see the documentation on how to supress the dialog within a macro using Logging file '<filename>.txt' but this doesn't work. I'm thinking it's a timing issue or the fact that the macro starts outside the scope of the dynamics runtime (AutoDim is calling the macro) so once dynamics is open and running the logging file command is out of scope? Is ther...

Find a empty cell in next column
hi. Dave helped me with this before, now i need more help. I use this code to find a column called PoF and the numbers written in the cells below it. This code work in every row/column (i dont need to name it). PoFRow = 0 PoFCol = 0 On Error Resume Next PoFRow = Worksheets(2).Range("PoF").Row PoFCol = Worksheets(2).Range("PoF").Column On Error GoTo 0 If PoFRow = 0 Then MsgBox "No range named PoF on worksheet:" ' & .Name ' Else Set numberPoF = Nothing On Error Resume Next Set num...

Run macro in new workbook
I have a programe that exports a csv file and names it dumporders.csv. I would like to be able to run a macro to format this data. How can I import a macro into this file without having to recreate it every time? hi, open the vb editor(alt+F11) on the left right click the module you want to export then click export. a save dailog box will apear. give it a name. it will export as a .bas file extention. remember where you put it. open the other file. open the vb editor. on the left right click the project name. click import. a dialog box will come up. select the macro you just downloade...

stop word 07 from automatic minimizing other apps like calculator
Word 2007 will automatically minimize new apps I open such as Excel or microsoft calculator. It will briefly display the app, then put it behind the open document. To use those apps, I have to minimize word, then expand it when I am done with the app. Is there a way to stop this? That's nothing to do with Word. It sounds more like an AV bug or a Windows problem. Maybe you have enabled X-mouse in the Mouse settings? -- Terry Farrell - MSWord MVP "doodlesquat" <doodlesquat@discussions.microsoft.com> wrote in message news:CF65CCFD-4428-4D3B-AC69-85A7509B0...

how to use a cell contents as a graph title
I want to be able to use the contents of a cell to set the title of a chart. Changing the cell contents would then automatically change the title of the chart. Hi, You can find details here http://www.andypope.info/tips/tip001.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Carl" <Carl@discussions.microsoft.com> wrote in message news:A26E519B-022E-4E8B-923E-B35A612FDA5D@microsoft.com... >I want to be able to use the contents of a cell to set the title of a >chart. > Changing the cell contents would then automatically change the ti...

Mirroring cells
I'm trying to duplicate cells exactly from one sheet to the next. I'm using IF commands to get the data entered in a cell in one sheet to show up in the next, but is there anyway to also mirror the format, i.e. bolded text, highlights, etc.? Thanks in advance! -- careyc ------------------------------------------------------------------------ careyc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26064 View this thread: http://www.excelforum.com/showthread.php?threadid=476778 Use Copy / Paste. It will copy both the cell's contents and its forma...

Chart scale automatically changing in ppt2007
I have a stacked bar chart that I update daily. Often when I update the datasheet, it automatically changes the scale of the graph on me. This is a problem because I have items that are not part of the actual chart but that I've added to it on the slide, such as carots pointing to the bars at certain heights. It seems that if I make the bars taller than some undefined threshold, it makes the chart change size and throws everything off. When I increase the numbers in the datasheet, I just want the bar to get taller, not change scale. Any suggestions how to make it stop changin...

Highlighting cells
Excel 2007 sp1 with vista 32 business sp1 Background: When you highlight multiple non-contigious cells (i.e. hold the control key down and select several cells that are not connected) Excel highlights the selected cells in light blue. Problem: This light blue does not show at all on many projectors. In some case you can adjust the color temp and this helps. We do hundreds of presentation in North America each year and can not control what projection equipment we will be using. Requested solution: I would change the light blue background that is applied to selected cells to some othe...

Format colorful for a cell (that has formula)
Dear All, Formating colorful for a cell that has formula is posible? For example: = "I'm " & 1 + 1 & "years old" And the desired result is: "I'm 2 years old" So, these is any way for me to do this. Please help. Thanks so much. OverA -- OverA ----------------------------------------------------------------------- OverAC's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3239 View this thread: http://www.excelforum.com/showthread.php?threadid=53585 You could write a UDF to test if a cell has a formula Function IsF...

Help with POPing errors due to messsages with suspect files
Hi: I'm having difficulty POPing mail from an Exchange 2000 server (using an Outlook 2003 client). Generally, everything works fine, however, occasionally, a message that is later confirmed to contain a virus, causes POPing to grind to a halt. Messages received after the suspect message will not download to the client! Both the server and the client are running Symantec anti virus plugins. What gives? Thanks for any help. -- Dab Cut off: yourhead to respond Dab <noThanks@hotmail.com> wrote: > I'm having difficulty POPing mail from an Exchange 2000 server (usin...

Forms time calculation
I am attempting to create a calculation in a form that will still enter it into the main table. I am attempting to calculate total hours of down time from entries in the DT Months, DT Weeks, DT Days, DT Hours, DT Minutes entry boxes. My calculation might look something like this: Down Time=(((DT Months*21)*24)+((DT Weeks*5)*24)+(DT Days*24)+DT Hours+(DT Minutes/60)) I would like it to display in the form as well as the table the form updates. I am a learn by trial and error and asking questions novice at MS Access and would like to get as much help as I can, please. Thanks to anyone who...

Get/Change Operation on SY_ResourceActivity
I am running Dynamics on SQL. I physically deleted SY00800 & SY008001 manually rather than running the delete query on the tables. Therefore, when I try to log into Dynamics now and get to choosing which company I want to use, I get an error message that is a get/change operation error on SY_ResourceActivity. Does some have the queries to recreate these tables, or is there another solution to this problem. I cannot find any solution to it on CustomerSource. Can you not restore your Dynamics database? That is your best option. Use at your own risk... this is from GP 8.0 CREATE T...

Display progress of a macro
Is there something like a status bar which gives one information about the progress of a macro Something like "Sub 1 executing" "Sub 2 executing - 50 lines processed" "Done" A Msgbox could work, but that halts the process - I do not want to halt the process. The immediate window could work, but then the VB editor must be open. I think I recall seeing something, but cannot find it now. Thanks Laurence There is something exactly like a Statusbar. In fact, it's called Statusbar <vbg>. sub aaaa() application.statusbar = "Hi from aaaa" &...

Change address and phonenumber to contacts in "new case" window.
If I am in the middle of creating a new case and talks with the customer on the phone...I wants to be able to change the customers address, phonenumber, computername, username....and so on in the New case window. I've got no time to find the contact and update this information and then back to the New case window and type in the customers problem. But I want to be able to change this information in both ways. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree&...

Time calculations #3
Excel 2003 I want to try to put together a store employee schedule for my son and I am wondering what is the best way to deal with time calculations. they do not use a 24 hour format so how can I do calculation (shift times, Employee availability times, sum of hours......) when the times are AM/PM format. Any guidance here will be appreciated. Thanks dave You can add and subtract times irrespective of the format. 17:00 less 08:00 returns 9:00 the same as 5:00 PM less 8:00 AM returns 9:00. You will need to use the number format to format answers correctly. When summing hours that ...

Appl crash after Inst. SQLServer2008Express due to new MFC in WinS
Microsoft SQL Server 2008 Express installs a new MFC Version in WinSXS folder (x86_Microsoft.VC80.MFC_1fc8b3b9a1e18e3b_8.0.50727.1833_x-ww_2fd6f5db). Therefore the previously used MFC 8.0.50727.762 in WinSXS folder is not used any more. Our Application does NOT crash using MFC 8.0.50727.762, but crashes with MFC 8.0.50727.1833 in CDialog::CreateIndirect What happens when it crashes in debugger? Is it your application or MFC which is responsible for this? Debugging will give clues about the problem. -- Ajay "Wolfgang Kruck" <WolfgangKruck@discussions.microsoft.com> wrote...

Outlook 2003: You do not have permission to change the current timezone
Hi All, Here is my current setup: OS: Vista Business 32-bit Outlook: 2003 Server Env.: POP3, no exchange server When I try to change the current timezone, I get the error "You do not have permission to change the current timezone". I was able to do that when I have Windows XP. I've already disabled the user access control but it is still NOT ok. Can anyone give me some hints? Thanks. are you changing it within outlook's time zone dialog or vista's? did you upgrade vista over xp? are you logged in with a user or admin acct? if a user acct, open the control pa...

changing investment types
I used to use Quicken 99 then changed over Money 2004 (both were Canadian versions). The trust unit investments I have from the pre Money days are all classified as mutual funds, as Quicken treated them as such. My new ones are listed as stocks, and I'm finding that more details (yield, etc) are downloaded. I can't find a way to simply change the old trust units to stocks. What would be the best way to do this? Thanks in advance. Fj In microsoft.public.money, fj wrote: > >I used to use Quicken 99 then changed over Money 2004 (both were Canadian >versions). The tru...

insert row below where the cell data is "Wednesday"
Can someone help me? I checked Excel Help and didn't find insert row based on data....thanks!! ....Lisa Excel 2003 look in vba help index for FIND if only one or FINDNEXT if more. Good example -- Don Guillett SalesAid Software dguillett1@austin.rr.com <gerry.lisa@gmail.com> wrote in message news:1156424702.624278.17530@i3g2000cwc.googlegroups.com... > Can someone help me? I checked Excel Help and didn't find insert row > based on data....thanks!! > > ...Lisa Excel 2003 > If you're trying to insert a new row when the values in a column change, may...

Cell format
I have a set of cells that show the fraction of #complete/#total. They are formatted as fractions so that I can custom format them such that those >=50% turn green and those <50% turn red. The problem is that for a completion of, say 8/12, excel automatically simplifies to 2/3. Is is possible for excel to still recognize the cell as a fraction but not simplify? You can directly control this by formatting in advance. Let's say you enter the data in twelths and want it to remain that way: Format > Cells... > Number > Custom and then enter # ??/12 Experiment with forma...

Slow Code Execution 02-11-10
Hi all, I have a some code that I am using to read the contents of each cell of the multiple rows in a 4 columned table. I am experiencing a slow down when my code gets to a particular line of code with is: Set myRange = oTable.Rows(i).Cells(j).Range when the table contains less than 100 rows the macro flies along really quickly, however when the number of rows is increased to 500 or so, my code grinds to a snail's pace, but strangely (at least in my eyes) this slowdown occurs on the very first line in the table.row.count is high (I would've thought that the cod...

Associate a cell with a number ??
hello i work in a medical center all of my patients have been given patient ID # Mr Smith = 276 is there a way that all i have to do in column "a" is put "276" and in the same cell in column "b" Mr. Smith name will show. jo -- Message posted from http://www.ExcelForum.com Hi have a look at VLOOKUP for this. See: http://www.mvps.org/dmcritchie/excel/vlookup.htm -- Regards Frank Kabel Frankfurt, Germany > hello > i work in a medical center all of my patients have been given > patient ID # Mr Smith = 276 > > > is there a w...