alert

I hope it is okay to post a new thread since this post was answered already. https://www.mrexcel.com/forum/excel-questions/299193-edit-links-startup-prompt-dont-display-alert-update-links.html?highlight=update%2Blinks Edit Links - Startup Prompt - Don't display the alert and update links. My...

Hi, In column B I have ticket numbers and there are 12 instances of each ticket (may grow). In column D I have clients. In column E I have specific text (e.g., alert, no alert, etc). In column AM I need it to show 1 or 0. I want it to only count the first instance of colum B (ticket number) and...

Hello everybody. I'm navigating IE with vba. Now, I need to answer "yes" to the following alert, as I do in manual navigation, to enter the intranet: https://imgur.com/a/J9SSbyI Consider: 1) the alert is exactly what you see in the image, but Current site and Intranet site are different (I...

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

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

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

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

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

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.

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

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.

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

- 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

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

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

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

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

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

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

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