+ Reply to Thread
Results 1 to 2 of 2

Multiply cells then perform IF else

  1. #1
    Registered User
    Join Date
    11-24-2014
    Location
    London
    MS-Off Ver
    Excel Mac 2011, V14.4.1 (140326) Upd: 14.4.1
    Posts
    20

    Multiply cells then perform IF else

    Hi all,

    Struggling with working this one out, I managed to get the code working with one sub calculating the cell multiply on a loop and then another sub performing the IF but because excel won't recognise VBA cell changes it wasn't triggering the second piece of code so now I'm trying to combine the two.

    This is what I currently have:

    Object:

    Please Login or Register  to view this content.
    Module:

    Please Login or Register  to view this content.
    Whats the best way to combine these so it loops the multiplication and then performs the IF statement on Cells(i,23) every time the user updates?

    Many thanks in advance

    Matt

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Multiply cells then perform IF else

    VBA is not responding to cell changes done in SquareMeterCalc and IF_Sections, because when these are called evnt triggering is switched off (application.enableevents=false).
    But I wouldn't switch it on as that would result in calling the worksheet_change event over and over and ultimately in a stack overflow.
    I guess you'd better use formulas to do these calculations.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 02-19-2017, 03:56 PM
  2. [SOLVED] How to multiply matching 2 cells with 2 different cells of 2 different table
    By k rabbi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-07-2016, 03:31 PM
  3. Replies: 3
    Last Post: 10-25-2012, 05:47 PM
  4. Multiply two cells based on information in two other cells
    By stanster in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2012, 10:04 AM
  5. how to sum up cells and multiply by 10, min 10 max 100?
    By urbanfox in forum Excel General
    Replies: 4
    Last Post: 12-11-2008, 11:39 PM
  6. [SOLVED] multiply cells
    By daniel in forum Excel General
    Replies: 2
    Last Post: 11-01-2005, 04:05 AM
  7. Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1