worksheet_calculate()

  1. K

    Multiple MsgBox on Calculate

    Hello, I am trying to create a code that when values in cells "g10:g13" goes below a specific number, a msg box pops up. I used the below. Private Sub Worksheet_Calculate() If Range("g10").Value < 352 Then MsgBox "T2 Low Stop Approaching! " End If If Range("g11").Value < 362 Then MsgBox "T3 Low...
  2. K

    VBA to copy data from one cell, based on data in another cell (formula output), and paste at the end of a table in another sheet

    I've been trying to figure this out for at least ten hours total now, and I have to admit I cannot do it myself. I'm just too new at VBA and too bad at programming. Ultimate End Goal: to create a table of Authors based on data entered in a primary table, upon entry or update, without duplicates...
    • keikii
    • Thread
    • author table transfer data vba worksheet_calculate()
    • Replies: 0
    • Forum: Excel Questions
  3. H

    VBA Worksheet_Calculate() Code Results in Popup Message Showing Twice

    Hi, I am a beginner with VBA codes, and I am working with the script below. Basically I have the D17:D36 range set as "No" responses. If a user selects "Yes" for more than one of the cells, then I want the message box to show up. The message box is working as it shows up, but I have to click...
    • hhoang3
    • Thread
    • message msgbox popup vba worksheet_calculate()
    • Replies: 3
    • Forum: Excel Questions
  4. V

    Refresh worksheets on open force any macros to run if required

    Hello, I am working on a Workbook_Open formula. Right now the formula works, but it's not forcing Sheet 11 & Sheet 12 to do something. Normally on those Sheets once you click V6 (which is a data validation drop down list) it activates a VBA code for Worksheet_Change which tests if V6=V2 on the...
    • VonFeed
    • Thread
    • application.run data validation (list) vba workbook_open() worksheet_calculate()
    • Replies: 1
    • Forum: Excel Questions
  5. N

    Private Sub Worksheet_Calculate()

    Hi, I am currently struggling with a Private Sub Worksheet_Calculate() macro. I have 3 areas of my worksheet that I wish to hide / unhide under different conditions. Unfortunately I am struggling to get 3 'IF' statements into the one sub. Here's what I have: I have also tried nesting the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top