alert

  1. V

    Maintenance alerts

    I am trying to create a spreadsheet in which every 12 hours an operator will in one column input running hours on a generator and every 150 hours of runtime I want an alert or email notification to let the operator know that it’s time to service the equipment
  2. J

    Generate Due Date Alert Problem

    Good Day All, I have been trying to activate an alert date on excel. I am using Excel 2013. Here is the function I have inserted: =IF(G719<(TODAY()+1),”DUE”,” “) I don’t understand why it is showing as ‘Due’ when my Due Date for Next action plan is empty. Is there something wrong with the...
  3. Nelson78

    VBA: navigating IE, problem in logging in

    Hello everybody. For one specific site, I've problem in logging in. When the macro runs, the id is correctly written in its field, the same for the password, but clikking the button the operation fails with the following alert as if nothing had written: All fields are mandatory...
  4. M

    Data Validation in UserForm base on worksheet cell value

    I am attempting to add data validation to a UserForm with textboxes. I need a way to have the userform alert the person entering data that an entry is out of range. This is for running hours of an engine and is entered daily, so 24 or less hours. I would also like to add in an alert for negative...
  5. L

    Popup alert for expiring date

    Hello my life savers! How to set pop-up alert for expiring date in Excel2010. Like I have multiple Items and I only have producing date, but they all expire in 1 year, and I (my boss) would like to get notification one month before it expires. Something like that. Code I made only worked for the...
  6. A

    Formula Issue

    I am looking to perform the following but cannot figure out what to do with the middle IF statement? =IF(A1<1,"SATISFACTORY",IF(A1>1,A1<1.25,"CAUTION",IF(A1>1.25,"HIGH ALERT","") I know there is a simple solution, hopefully. Thanks.
  7. G

    VBA Pasting

    Hi, Ive created a helper cell in column S to identify some rows of data I want copied to a new sheet. The code below works, but the paste is literally pasting into a new sheet ("Alert") at the exact row number it was copied from. Some of these rows are thousands of rows apart from each other...
  8. M

    Need help for alert

    Hi All I need help in excel i need alert written in front of number which includes same numbers like 555.50 2345.50 I need alert that this number contain 5.50,similarly if number is 2777.70 , i need alert that this number contain 7.70. Thanks is advance.
  9. T

    Adding another formula

    So....... I very kind gentleman on here helped me with my spreadsheet. Essentially, I have a book with a sheet that has conditional formatting and formulas that then highlight on an 'alert' cell on another sheet....... The formula (which works) that he created was...
  10. C

    Disable Alert Messages

    - I have various alert messages programmed for textboxes on a userform Question - I do not want any alert messages to display upon clicking the red x on the top right of the userform Thanks OJ
  11. P

    Create an Alert Message if a value is lower than expected

    I have a macro that formats data and I would like one check for a value. If the value in the sheet called "QualityCheck" Cell c15 is less than 25, then create an alert message "value is less than 25 - verify inputs". They can then click "OK" and the macro should continue on. Can I get a...
  12. A

    Nested IF-MATCH

    Hello, I'm trying to create a single column that populates cells based on a unique identifier that can be matched to either column A or column B in a different sheet, but I can't get it to work. When I create my formula for just column A or column B, they work: =IF(MATCH(F2,'Hot Alert...
  13. S

    VBA Stop message

    Hi, I am trying to create a code that will create a stop message if a field is left blank. I have a macro to go to the next page that I want to change. It is not working correctly and I don't know what I have done wrong. The caveat is there are 16 hidden cells that will highlight grey based on...
  14. R

    VBA code for an alert when cell reaches some date

    Dear all, I have a excel file with some deadlines and tasks. What i'm looking for is a vba code or formula to alert me which task is available for the day, when i arrive to the office. Also, I'm trying to, in some tasks, send a email with the fields "To", "Cc", "Subject" and "Text/message body"...
  15. L

    Excel e-mail alert

    Hey there everyone, I have Ben stuck for a while, I was asked to create an email alert whenever the each cell in row Q reaches the number 15. Iv tried many ABA codes from Rounding (Send a mail when a cell reaches a certain value), and have no problem with the email macro but can't seem to get my...
  16. O

    How do I clear or remove a JAVASCRIPT Alert message box in the InternetExplorer.Application Object?

    Hi I am relatively new to using the VB language and I’ve run into a slight hurdle. I’ve searched this site and others for a solution but I can’t find an answer that works. I am using VBA to login to a private (work) intranet page and then process data within the page. I can’t edit the page...
  17. F

    48 Hour Alert Formula ( Help )

    Hello, I need a formula that will look at a date and spit out a date 48 hours later. Here's my problem, It has to exclude the weekends? Here is the formula I'm currently using, however it seems very accurate excluding the weekends. =IF(WEEKDAY(I25+5)=1,I25+6,IF(WEEKDAY(I25+5)=7,I25+7,I25+4))...
  18. N

    Send Email When...

    Hi folks... I have been reading other threads and other locations online, but they are all assuming I know a lot about VBA, and I do not. I would appreciate step by step help... I want to use outlook, and I do not want excel to have to be open to send alerts, but should work when open as well...
  19. T

    Replacement Warning won't go away HEEEELPPP

    HI there fellow Excel hackers. I have an interesting issue that i have run across while trying to write a script that do a replace and find of text in excel spreadsheets. I am writing my script in VBS because of the complexity of this script. This script is to do the following - search a...
  20. JDaniluck

    "File In Use" Alert

    Hey All, This is my first question on this site. I use it all of the time by searching through the forums. So I thought I would finally join in the fun. :) Anyhow, time for business. I am running into a problem with the "File in Use" alert. I am attempting to write a code to automatically...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top