I'd like to be able to show a messagebox of some sort (or any type of visual alert) plus display an audible alarm (or wav file) when a formula condition is met in a certain cell. Is this possible?
View 14 RepliesCan excel be made to play an alarm if a condition becomes true?
View 5 Replies View RelatedCells in Columns A & B (57 rows deep) have a real time data feed and can have values of blank, "H", or "R". The H and R can remain in the cell for any length of time. I would like to have an audible ding go off whenever a new H or R appears in columns A or B. Is there a cell formula that can do this? I think a macro solution would not work, because the workbook has a macro that activates every 10 seconds, so I assume a macro solution would interfere if both macros happen to activate at the same time.
View 9 Replies View RelatedHow 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.
View 2 Replies View RelatedI am an avid greyhound racing fanatic and I would like excel to sound an alarm when a race is due. I have entered all the race times down one column A1-A146 in this format 08:33, 08:37 etc
Is there a way to get excel to use the system clock and check these times and sound an alarm 1 minute before the the time I have entered, i.e. 08:32, 08:37 as in the above examples?
I am trying achieve the following. I have bracketed each part seperate part for clarity.
(if a1+b1+c1 = 10 or more), and (a2 = 10 or more) and (b2 = 10 or more) (then sound an alert) (and display the number 1 in d1) (if not ignore).
I can do parts of the formula but i am getting very very confused trying to combine them together. I am trying to make this formula work in d1.
Can anyone tell me if this is a valid piece of logic that can be represented by an excel formula.
Is it possible to place a alert just like conditional formatting, where we can change the color of the Cell?
Say cell value is 98, and a would like to receive a sound alert wen its 100. not the windows slow sound, but a sound of my choice?
I would like to create a sound alert if the answer to an "if" statement is false. I am using Excel 10. Can it be done, and if so, how?
View 5 Replies View RelatedI have a date base that is used as a job status board developed in excel that has locations, times, clock and other areas. What I am looking for is a way of playing a sound when the time approaches 5 min before the time in the excel cell that has been entered into the job status board...
View 3 Replies View RelatedI have created a program to display an Alert based on a Date. I have this program enlcosed in the Workbook Open event. I need to popout this alert everyday, everytime EXCEL starts on a computer.
I had something in my mind though - I thought of plonking this program into the Workbook Open event of the Personal.xls workbook for a computer and thereby I could have achieved my requirement of popping out this alert everytime when Excel starts. However, there is one problem here. Every 3 to 5 days the dates in the workbook are going to change and I do not want the user to tamper with Personal.xls on his / her computer.
So I gave it a second thought. I created a shortcut of this workbook and placed it in the XLSTART folder for a computer and now the problem is - it opens the workbook itself rather than popping out the alert whenever Excel starts on the computer. So this would not work too.
Is there any other way I can make the alert pop out everytime I start Excel on a computer ?
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.
View 5 Replies View RelatedMy colleague in accounts has a sheet that lists all the invoices and values and other 'accounts department things' that I know little about.
Anyway, she has to manually input all the invoices she receives onto this excel document but sometime receives duplicate invoices (& inputs them twice be accident).
Is it possible for someone with macro skills to create a macro to run in a worksheet so that if she enters a number in a given column more than once an alert box appears to tell her. I've summarised the 'rules' below*
*Can is be written so that I can edit which column the alert is based on?
[In (for example) column F is a list of invoice numbers - all unique]
If user types a number in column F that matches a number that already exists, show alert box "THERE APPEARS TO BE A DUPLICATE ENTRY IN COLUMN F"
====
Any further clarification, let me know i'll try to post a blank sheet if my boss lets me.
I have a spreadsheet which has a sales report for 100 stores. When a store opens the spreadsheet they login using a username and password on a userform. This then filters the report and brings up there respective line. The stores have to fill in certain cells on there line. I want to display an alert if they forget to fill in a cell when they login.
View 2 Replies View RelatedIn as much as I would like to heed the advice of this site to avoid setting excel calculation to MANUAL, I think I have no choice this time. I have a file that uses a lot of SUMPRODUCT(--) and array formulas. DSUM would have been faster but this file I am working on will be sent to users who barely knows excel. When they need to insert rows, the DSUM criteria will have to be reestablished and I do not think they are capable of that. Anyway...when calculcation is set to manual, all excel does to warn users is the little test "Calculate" in the status bar. What I would have liked is that a red button with text "CLICK TO REFRESH" to appear when calculcation is needed i.e. status bars is showing "Calculate".
View 2 Replies View RelatedIs there any way I can display line numbers against the code in the Visual Basic Editor?
Or can I see in the current line number in the status bar?
or GoTo Line number?
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.
What is the best way to do this?
I would like to do is develop a stand alone program in Visual Basic ( not in Excel VBA) to update the price file in our Portfolio system automatically using the downloaded Excel format file csv extention file from the BigCharts. But before that, I need to export the *.pri file from our Portfolio system in to Excel which still saves as *.pri extention. Then once it updates, I import the updated *.pri file back in our Portfolio program. I understand that the Excel VBA code can be incorporated in Visual Basic code provided there is an object declaration for Excel file (In this case eventhough the both files are in Excel format, they don't have xls extention). how to use external files and Excel VBA code in Visual Basic?
Below is the code that I currently have in Visual Basic. What I'm trying to accomplish is using the ticker (eg. msft) as a keyword search to look up in the price file. If found , the price of that ticker from the test.csv file will be copied in to the price file which is test.pri. I haven't ran it yet.
Sub UpdatePrice(BigChartPath As String, BigChartName As String, AxysPricePath As String, AxysPriceName As String)
'Below are Excel VBA codes
'Uses the test.csv to look up tickers in test.pri and update the price in it
Dim PriceFile As Workbook, BigChartFile As Workbook
Dim PriceFileSheet As Worksheet, BigChartSheet As Worksheet
Dim MaxRows As Long
Dim PriceFileRow As Long
Dim BigChartRow As Long
Dim BigChartFound As Boolean
Call CheckBookOpen(BigChartPath & BigChartName)
Call CheckBookOpen(AxysPricePath & AxysPriceName)
Set BigChartFile = Workbooks(BigChartName) 'Big Chart website imported CSV file saved as test.csv...............
I wanted to set the time alarm in a cell , is that possible in Excel .
View 9 Replies View RelatedI have a training list file i made in excel that I put what people are trained on, the date they were trained and automatically it adds 2 years to the next column for when they need training again.
What I would like to do is make a macro, that will pop up a box (upon opening the .xls file) that states any of the employee who are due to be retrained, as well as what items they need retraining on.
I'm trying to write some VB code that will call up a sound file each time I give a new cell focus.
Example:
Cell A1 holds value "Hello"
I'm trying to write code that calls a sound clip I've recorded that says "Hello" when I select A1
Any suggestions?
How can I silence the annoying beep heard whenever a msgbox pops up or an error box appears?
View 9 Replies View RelatedThis is what I have,
Private Declare Function PlaySound Lib "winmm.dll" _
Alias "PlaySoundA" (ByVal lpszName As String, _
ByVal hModule As Long, ByVal dwFlags As Long) As Long
Const SND_SYNC = &H0
Const SND_ASYNC = &H1
Const SND_FILENAME = &H20000
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If UCase(ActiveSheet.Range("S41").Value) > 99 Then
FName = "C:windowsmediading.wav"
Call PlaySound(FName, 0&, SND_ASYNC Or SND_FILENAME)
End If
End Sub
but I cant get it to work!
All I want is for it to play a sound when My Value in S41 goes over the Value 99
the value is part of a simple formula of sums.
is there anyway of playing a sound once a user opens my excel file???
View 3 Replies View RelatedI have made a standard Demo Workbook for testing Wav file VBA in this case.
It shows the problem code and a series of counters.
When the RED macro button is pressed, it should show the error code. and below a brief explanation.
I don't think it is an actual error as such, but I ask for an alteration. Once the code is solved, the GREEN button should work. If the demo book is downloaded it will explain better.
I recently installed Office 2002 onto a new computer and found that whenever I drag-and-drop any amount of data from one cell to another, a loud obnoxious noise plays when I release the drag-and-drop data.
I was using the same version of Office on my old computer and did not have this problem.
I'm guessing it's a clipboard issue, since when I open the Excel clipboard (where I currently have all options as unchecked) and copy something so it is captured there, the same noise plays.
I already have turned off Windows sounds via the Control Panel and have no clue how to turn off this sound.
Just want to know if there is a way to play a sound based on the value of a cell. In this case, if the cell says "S" then the sound is a low note and if the cell says "L" then the sound is a high note. If the cell is "" then there is no sound.
View 1 Replies View RelatedIs there a way to get a sound toggle button on excel?
What I need is a button to turn the sound alerts on and off on my spreadsheet. Ideally I'd like a button that either changed an image to the speaker image when on and the speaker image with line through it when off. Is that possible?
If not, is it possible to have a button that just says: "Sound:ON" or "Sound:OFF"?
I guess it could be done with tick boxes, or drop down options.
The macro below is adding the SUM cell. Is it possible to make a beep sound when SUM cell value will be the same as one on the left?
[Code] .....
I have an automated sort descend happening all day. The top several cells are coloured green and if a cell jumps to the top from below the green cells, I would love a warning sound. Is is possible to activate a sound if a cell changes from a colour to a non colour. Preferably if any of the cells within a range of say F2: F6 changes from green to a non colour.
If it is not possible to have a change of colour to activate the macro, I could get around it by - if any cells in a range of H2:H5 >than 1 it plays a sound.
vbInformation, vbExclamation, etc makes the associated sounds, but vbQuestion does not make any sound. How do make vbQuestion sound off?
View 7 Replies View Related