I have a worksheet with various information contained in each row and using up to columns M. Each row represents a new product and new products/rows are added weekly. In columns H is the date which is formatted like "*14/03/2007" and displays as that.
What i want to do is when the 11 months have past since the date in the cell i would like the cell colour to change to YELLOW. When 12 months have past then i need it to change to RED.
Date in cell is 18/05/2007
When date reaches 18/04/2008 i want the cell to change to YELLOW
When date reaches 18/05/2008 i want the cell to change to RED
I would like the code to apply to all cells in column J.
I just discovered VBA coding today and was wondering if I could use it as an audio alert. I found a couple examples online but donít understand the coding language of excel. I have a feed link from my trading platform to excel that feeds in live data. What I would like to do is have an alert for when Range ("C4").select is >=1000 Alert Ring.wav and when Range ("C4").select is <=-1000 Alert Chimes.wav.
I have a vba process that develops statistics/graphical output via SQL queries of pretty large datasets. This usually takes about 2min, so I run it via a form I've build, and then go do other work or play on the net, checking and rechecking if it has completed. I do have a msgbox once the process is complete, but if i am not actively in an Excel window, I will not see it. Is there a way to force the windows taskbar to flash or something so i can see that my process is complete if i am not in an Excel window?
Each month I get a report that I process using a macro. The problem is that each month the name of the file changes and is different. When I run the macro and it crashes I have to de-bug by going through the code to change all references to the file name from the the previos run and change to the latest file name and then re-run the macro. There must be a better way.
I would like to learn the code that sees the open book and then refers to it for the run.
In the attachment you will see I have two tabes called License-Equanet and License-Dell, on each row i show an expiry date.
The first sheet is called 'Due to Expire'. One month before an expiry date is reached in the licenses tab I need the information in that row to appear in the 'due to expire' tab. This will then alert me one month prior to the license expiring.
I am trying to add a sound alert to a junior athletics recording program. The date of the meetings is in column (A), results are entered in column (B) for a particular event, say 100m sprint. Column (C) & (D) contain formula that recognise if that athletes result is a personal best (PB) result or a club record (CR). I am after a code that will play a sound when a new PB or CR has been achieved. I have downloaded the sounds I want into the office media file. I am new to VB codes. Any suggestions?
In ("a1") i have a time e.g 12:30 in a2 it is 1:40 ......................etc i want a vba code that play a file.wav when the time exactly as in a1 then play it agin when it as in a2 repeating it self to .............a12
I have a chart that's being updated with different values when I cklick on different radiobuttons. When the cells that the radio button refers to is empty or the calculation in the cell have an error it pops up a message that I need to click OK to go on. Is there a way to stop these alerts by writing a script that shuts the alert messages off during each click?
I have to prepare invoices daily basis..i have to write name in attached sheet i.e cell D7 and Operator name in G13..some time my boss catch my mistake that this operator is for any other company and some time he catchs that this company is for any other operator..
I have a list as there..kindly advise me if my operator is not equal to my company or my company is not equal to my operator as per my list in sheet 1 than a alert massenge should come there so that i would not continue typing till i correct it..
Is there any validation formula or any other advise..
existing workbook that has evolved over several years, there are bits of data spread all over the sheets and there are several sheets.
My question is. Is there a way to show/print/email an alert with a reminder message any time any of the formula cells gets changed, something like "Be aware a formula is being changed, make a note of the changes."
I entered an activex object command thing.. and now I'm not sure how to exit out of it.. it just keeps alerting errors messages like reference is not valid and other ones depending on what I type in the formula box.
I just want to remove the object, but I can't get past the error alerts.. they just keep coming every single time I click somewhere on the workbook trying to exit out of it.. so I'm not sure how to even get out of it.. I don't want to open up Task Manager to exit out of the entire program because I didn't save my workbook.
How to create a macro which would search through certain columns and post an alert/notification with the employee name (at the top of the column) and date (to the left of the column) if the cell value is less than 12.
If I already have lets say 90% on B9 and I try to enter 15% on D9 it wont allow me because of the total being over 100%, but how can I have an alert to say Please enter 10% or less.
If I already have lets say 50% on B9 and I try to enter 20% on D9 and I try to enter 50% F9 it wont allow me because of the total being over 100%, but how can I have an alert to say Please enter 70% or less (the sum of B9+D9).
Can this be done using VBA?
I've attached the file that has the data validation.
I have the below VBA code which does not seem to be working. I want to have an email alert as soon as some Excel is saved. THis is the code I am using. Office 2007 is used, I have Enable all macros under trust centre settings.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim OutLook As Object Dim OutMail As Object Const SendTo As String = "email@example.com" Set OutLook = CreateObject("Outlook.Application") OutLook.Session.Logon Set OutMail = OutLook.CreateItem(0) With OutMail .To = SendTo .Subject = ThisWorkbook.Name & " is updated" .Body = " Needs your attention!" .Send End With Set OutMail = Nothing Set OutLook = NothingEnd Sub
Is there any way to get Excel to disallow you to enter in unique values into the same column? Like I know you can search for and delete duplicates, but I am wanting to get excel to disallow duplicates from being entered and/or give me an alert that what I just entered is a duplicate.
I am trying to set up a warning. If an amount is entered in columns u,v, w a warning box to appear telling the clerk to enter a comment in col ab or what I would really like is if they enter an amount the cursor jumps to comments with a command for them to write an explainations.
Do you have a way to do this. (excel 2007)
Col U V W X AB Held Amount Write-off AmountTransfer from Proj. to Proj. AmountFinal Invoice Amount Comments $ 5.00 $ - $ - $ 273,143.29
My macro cuts and pastes a section of one sheet over the top of each remaining sheet in the workbook. It pauses before each paste and presents a message box (relating to copying over a named range) requiring the user to manually click on "Yes" in response to the question before continuing on. How can I modify my macro so that it finishes without requiring the user to click on "yes" for each sheet. In other words, how do I get the macro to automatically answer "Yes" to the message box ??
I have to send some data on hourly basis i have a macro that extracts the data from the master sheet and creates a new workbook for the same and saves the same. Problem that i am facing is that i need to save the file with the same name. and on doing that it shows a pop up that do you want to replace existing file. Is it possible to stop this pop up. Code that i am using to save the workbook:
ActiveWorkbook.SaveAs Filename:= _ "C:Documents and SettingsAmritDesktop Training Scedule For Next Hour.xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False, ConflictResolution:=xlLocalSessionChanges
How to create an audible alert in XL. To be more specific, I would like the system to alert me on various due dates for the data entered. The key filed is the DATE. The due dates for re-validation could be between 07 days to 3 years.