1. M

    Need help with macro

    Hello! I am trying to use the below macro to flag an error message when a date range exceeds 7 days. I have used the below which only applies to the first cell in the column. What must I do to apply it to the whole column, I have 350 rows. Just to let you know column K is a calculation of...
  2. D

    Excel notifications by email/warnings inside the program

    Hello everybody, My current excel-file looks like this: I would like to create a macro that, once I click on it, checks if the quantity is less than or equal to the minimum stock. So in the photo, for row 2 where material number "6046100" has a minimum stock of "1" and the quantity on the...
  3. D

    Create macro that sends out emails when quantity is less than or equal to minimum stock

    Hello everybody, My current excel-file looks like this: I would like to create a macro that, once I click on it, checks if the quantity is less than or equal to the minimum stock. So in the photo, for row 2 where material number "6046100" has a minimum stock of "1" and the quantity on the...
  4. T

    VBA: MsgBox Warning if row is hidden

    Hi all I'm new here and kinda of new to VBA, but trying to learn. I have a bit of a tough one (for me at least). I am trying to write a code that can do the following. Whenever a row is hidden manually if the row contains a value greater or smaller than zero, and not text string in...
  5. B

    Disable read-only warning in yellow alert

    Is it a new thing all of a sudden that Excel is warning me that my file is read-only in the yellow security message towards the top of the sheet? Can I disable that somehow? To be clear, I want to keep the document as read-only, but I don't want to get warned about it every time I open it.
  6. D

    Help - Slow Performance on File (Experts Needed)

    I have an issue with a Gantt Chart Template that I created, its very slow for some reason (I cant find the root cause :warning:) Could you please take a look of it and support me to speed it up? Thanks a lot!!! Download Link: https://drive.google.com/open?id=1nU...nDEKAB0iePAH6a
  7. S

    Warning about duplicate entries

    Hi, I have a table that we use to help schedule employees and want some type of warning if we double book them. It is setup as such: <tbody> A B C D E F G H I J K L M N 1 Name Job# Loc 6/25 6/26 6/27 6/28 6/29 6/30 7/1 7/2 7/3 7/4 7/5 2 John A X34 USA D D D D D D D D D 3 Joe V45 CAN N...
  8. N

    Messagebox to run macro not working

    I'm trying to use an Ok/Cancel Message box to run a macro, however, it's just not working If I use the below code regardless of if Ok or Cancel is pushed the macro will run Sub Button()' ' Button Macro ' Dim Answer As String MsgBox "WARNING: The following process will clear all of today's...
  9. A

    Warning Message if Cells Match

    Hi i would like to have a warning message box pop up if i enter a value into a cell that matches a value from another range of cells. The range of cells with preset values in it is P3:P10 If i enter a value in the range R3:AC10 that matches one of the values in the range P3:P10 i would like...
  10. G

    How do I put read only warning on macros

    Hi I have macros that are shortcuts to books that numerous people use. I know how to record the macro to open the book but dont know what to add when its opening as a "READ ONLY" as in the message box warning it read only. Can anyone help?
  11. L

    Conditional Formatting Rules for variable messages

    Hi Experts! I am trying to formulate the best way to create conditional formatting rules to be able to highlight the whole row based on the words found in column G. Basically, column G contains all the status of the processing of the macro. It is consist of a sentence or two. I want the rule to...
  12. C

    Macro disbled

    Hi, Trying to enable macros to run on excel binary sheet. I have changed the trust centre settings to enable all macros but still get the security warning and unable to run any macros ? Thanks in advance
  13. D

    Message box to display warning if cells are not filled out

    I have an excel table and upon creating a new row, I want to add code to display a warning message if columns A, E or F are not filled out. What would be the code for this? The table is called tblCosting.
  14. C

    Variant not appearing in MsgBox?

    Hi There, Could someone take a look at my code and tell me how to fix it please? It's a simple code that was given to me by one of the forum members and after trying to implement it into my workbook I have come across an issue and have not been able to resolve it since. Basically I have an input...
  15. S

    VBA warning message when specific drop down selection is made

    Hi,would the following be possible with VBA...I would like a warning message to pop up when a particular selection is made from a drop down list in a worksheet, or in a specific range if it must. However, I want the message to pop up only the first time that selection is made, so suppressed...
  16. M

    Won't change name

    I want to have a cell change from "Warning" to "Passed" based on a True or False statement in another cell. It works fine and says "Warning" when TRUE, but when it says False it stays "Warning" and does not change to "Passed" Thanks in advance for any help. (I am a novice at this)
  17. freelensia

    Connection to XLAM file on OneDrive triggers "This workbook contains links to one or more resources..." warning

    Hi, I have developed an Excel Add-In. The add-in is stored in C:\OneDrive\XJ15 Macros\Live\Freelensia Macros.xlam Note that the OneDrive folder has been moved to C Drive and the add-in is stored there instead of in the Personal Add-Ins folder. I have Excel connected to this add-in via Options...
  18. B

    Excel Negative Value Warning

    Hello, I'm working on a primitive inventory sheet and came across this: https://www.mrexcel.com/forum/excel-questions/141057-negative-value-pop-up-warning.html From here: Private Sub Worksheet_Calculate() For Each cell In Range("B5:B16") If cell.Value < 0 Then MsgBox ("Warning: Negative...
  19. C

    VBA warning box

    Hi all, Bear with me - I am a VBA novice so any help would be appreciated. We currently have a workbook which has a lot of tabs at the bottom. One of the tabs is called 'Shortcuts'. I am trying to write a VBA whereby if cell P43 on the 'Shortcuts' tab contains "1" a warning pop-up appears...
  20. B

    Suppressing "No Subject" warning in Outlook 2010

    Hello! I had a macro in Outlook that was working perfectly well in suppressing the "No Subject" warning. Due to inferior hardware here at work the only way I can be sure my work is truly saved is to email it to my home email. I do this 50-60 times a day when I am on a project. For some reason...

Some videos you may like

This Week's Hot Topics