Beep and MsgBox in VBA for Excel
Can someone tell me why EnableSound set to false didn't do the trick for me?
Application.EnableSound = False
YesNoStatus = MsgBox("Are you sure you want to delete Protocol " & PName, vbYesNo, "Deleting Protocol")
Application.EnableSound = True
You can use the Beep action to sound a beep tone through the computer's speaker.
I would like to design my vb code to enable my computer to make a beeping sound when a message box is activated, and then to stop (the beeping) once the user hits a yes or no. The beeping would alert the user that he/she must make a decision.
I'm really not sure where to find this information and would greatly
I have an excel spreadsheet with several columns. To verify that data has been entered correctly I have a column that adds all the columns and should equal zero if they are entered correctly. Since the "proofing column" is not always visible unless I tab to the end of the worksheet, I would like to hear a beep if the column is greater than zero to signal that I need to check my entries. It would be great if I could see a dialog box that would tell me my entries are not correct.
Related Applications & Scripts
VBA Key resets passwords to view Visual Basic for Applications (VBA) projects source code.
VBA is a Microsoft Office component and is used by such applications as Microsoft Excel, Microsoft Word, Microsoft Access, AutoCAD, etc.
State of the art password recovery engine - all files are unprotected instantly
All Office 2010/2007/2003/XP/2000/97 products are supported: Word, Excel, Access, etc. Updated!
Multilingual passwords are supported
Full install/uninstall support
Demo version recovers passwords containing no more than 3 characters.
Lets you add an user email account to windows 2003 pop3 service using script or other programming environment. The script bellow is written in VBA 6 (You can use it in Visual basic 6, Excel, Access, ...), you can simply modify the script for VB Script or VB.Net. The function uses P3Admin.dll and it's programming interface. You can manage the accounts locally or remotelly. You will need P3Admin.dll, P3Store.dll, Pop3Auth.dll, Pop3evt.dll, pop3perf.dll and pop3snap.dll DLLs (registerred using regsvr32)
Febooti Command line email client is powerful but easy-to-use email sending utility, which supports all of e-mail client sending capabilities.
With Febooti Command line email you can send mail directly from windows command line (DOS prompt). You can attach files to email, use HTML e-mail messages, use CC (Carbon Copy) and / or BCC (Blind Carbon Copy). Call Febooti Command line email from Scheduled Tasks, CGI scripts, VBA, virtually from any software, also can be used in automatic email tasks and MAPI replacement.
This component can be used for the generation of sound using system speaker by any applications that support ActiveX components: VBScript and Jscript, ASP (IIS), VBA for Access, Word and Excel, etc.
The component can be used by system administrator for the alert of predefined system events like port scanning, intrusion detection, applications running, read of specific pages or files, etc. The frequency and duration of sound can be set so that different sound patterns can be assigned to different set of events. Also a developer can use the component for applications debugging, i.e. testing ambiguous conditions, catching not handled exceptions, etc. ASP developer can avoid using response.write and Session variables for debugging and use predefined system sounds for a set of predefined events. You should use the component carefully since the execution of applications stops during sound.
SimpleIPC is a set of objects, server processes, and configuration tools which allow you, the software developer, to have some of your application's work performed in an external process on the same machine. You make function calls to objects in the external process as if they were local objects. "Under the covers", you're using .NET Remoting over the IPC (Inter Process Communication) channel, but you don't need to be an expert on .NET Remoting to use SimpleIPC. The platform handles the communications and external process life cycle details for you. SimpleIPC runs on Windows, and the code to be run in the external processes (i.e. IPC servers) must be written in a .NET programming language. However, your client code may be written in a variety of languages, to include Java, VBScript/VBA, and .NET programming languages. In this way, SimpleIPC provides a straightforward interop between Java or COM and .NET.
You might consider using SimpleIPC under the following circumstances:
1. You have some code which is useful, but which has the potential to throw unhandled exceptions and crash your application process. You can run this code via SimpleIPC. If there is a process crash, it will be one of the expendable external processes, rather than your application process. Your application can just repeat the call against a different external process and continue on. There is no need for your end users to be impacted.
2. You have some code which is useful, but which leaks memory. You can run this code via SimpleIPC and configure the external processes to recycle frequently. In this way, you can keep your application's memory consumption under control without sacrificing functionality.
3. You need an expeditious way to perform one of several common programming tasks, such as invoking .NET code from a Java application, running a subset of your application's operations under a different Windows identity, or limiting concurrent access to shared resources in a multi-user environment.