warning

Hello eveyone! I have this sheet: ABCDEFGHIJK1NI :0806100USADAS2NF :08061503TOTAL AWB514SEQUÊNCIACHECK DIGITSEQ + DIGITAWBColuna1AWBAWB25080610018061 1001047 - 8061 100180610016080610128061 1012047 - 8061 101280610127080610238061 1023047 - 8061 102380610238080610348061 1034047 - 8061...

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...

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...

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...

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...

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.

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

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...

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...

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...

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?

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...

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

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.

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...

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...

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)

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...

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...

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...