1. E

    How do I create a Pop-up Notification/Reminder in Excel?

    Hello everyone, I'm hoping someone can help me with a bit of dilemma. I have a long list of cases that I am working on. I have to be reminded on which ones to chase everyday. I have used conditional formatting where certain cases are coloured which kind of helps, but as the list gets longer...
  2. M

    VBA Expiry date with entire row Color highlight & new column with status

    I'm trying to write a VBA CODE example mentioned below. Help on the below-mentioned example A B C D SL NO PRODUCT MANUFACTURING DATE EXPIRY DATE 1 ABC 01-01-2021 01-01-2022 2 XYZ 29-03-2021 29-03-2022 3 CDA 04-05-2019 04-05-2020 4 TWC 23-03-2021 23-03-2021 I want my output as...
  3. G

    VBA Email notification

    Is it possible to have an email notification when one of my files is open by another user? I have used MsgBox and With Outmail code before but it was when someone ran my macro. I wasn't sure if it can be done with my file is opened. Thank you in advance.
  4. M

    Index Match Error

    Hi I have a table <colgroup><col><col></colgroup><tbody> Country Client Notification Date BRAZIL 31-May-19 CHILE 20-Aug-19 INDONESIA ISRAEL MALAYSIA 02-Sep-19 NEW ZEALAND PANAMA PERU PHILIPPINES SAUDI ARABIA SOUTH AFRICA TURKEY UAE (DUBAI)...
  5. Z

    VBA Create Table Column of SQL Server for Binary-type Data

    Hi All, Below is the code I use, currently facing the problem to declare the datatype of 'Data' as Binary-type for file upload. Sub ImportToDatabase() 'Import Data to SQL Server Dim conn As New ADODB.Connection Dim adoCmd As Object Dim iRowNo As Integer Dim Notification...
  6. R

    Please Help :)

    Hey All I need an excel formula does the following calculation: Notification Date Exit Date Cost July18 Aug18 Sept18 Oct18 Nov18 Dec18 Jan19 Feb19 Mar19 Apr19 01st Sept 18 31st March 100k 14.3k $14.k $14.k $14.k $14.k $14.k $14.k I need...
  7. B

    Expire date notification multiple columns with blanks.

    Hey All hope all is well, I'm hoping to get a little help with a notification when a date is near expire date. I have several columns of when employees training certificates expire, I would like excel to tell me in A:7 that the dates expire soon. some of the columns have blanks, I have this...
  8. J

    Need a Notification/Alarm when a file is left open for too long

    Hi There, I have a problem that I'm sure many folks have encountered. Our office utilizes a shared drive to access documents. It has its pros and cons, but we've recently run into a problem. There is a coworker who keeps forgetting to close an important excel document that is often used by...
  9. R

    Emails from Excel (via VBA)

    Hi Need your assistance on this I have the following table and I am trying to - automatically send an email via Excel based on the Status (Column 5) to the Travel Asst. (Column 22, as 1st notification point) and Travel Manager (Column 23, as escalation) - in the escalation, copy the Travel...
  10. F

    Personal Macro disable notification

    Hi there, I have a personal macros in Excel which I use and I always get the below message when trying to open other workbooks if I have one open already. Is there a way to not have the notification pop-up? Thank you
  11. M

    Message Box Notification when cells in Column have a specific value

    I was wondering if anyone can help me with my message box notification. What I want the macro to do is to check the values in column H and if it has a value that is <= 60, then to have a message box pop up with a specific message. Then I want it to do the same thing for <= 30 with a different...
  12. T

    VBA code to send email notification.

    Hello all. I am working on a workbook where I have inventoried items at my work place. This workbook contains quite a few pages and also over a 100 items per page. The idea with this was to have someone update the inventory and then when they save the file, it sends an email to the person...
  13. T

    Disabling macros in Excel 2016

    In previous versions of Excel, if I hold down the shift key whilst opening an excel workbook, macros are disabled. Alternatively, if the macro security setting is set to "Disable all macros without notification", macros will also be disabled. However, in the Excel 2106 64 bit version, I have...
  14. J

    VBA - Email notification when job added to list.

    Morning All, Within my department we use an excel based job register for employees to add engineering issues as they occur. Currently someone within my department has to sporadically check the register to see if any new jobs have been added and then assign them to an engineer and give it a...
  15. A

    How to know if "disable all macros with notification" is ticked?

    Excel friends, I found the thread below to know if "Trust Access Visual Basic Project" is ticked. It works perfectly, but in addition to it, I also need to know if "disable all macros with notification" is ticked. The ideal will be to identify which one of the four is ticked. Is there any way...
  16. A

    No Notification if you want to save before closing an excel file

    Hi, Can someone help me, it is very odd just recently I stopped receiving notification if I want to save an excel file before closing when I tried to close an excel file. Usually I receive those so I will know if i saved the work I've done or not. Can someone help me how to bring it back?
  17. P

    Devide cell values based on new line

    I have a table with 2 columns. I would like to divide all the values in column B into new row based on the char(10) end of line. Sample table - before: <tbody> Product code Description 110/1 - manual operation - high voltage - yellow color - email notification 110/2 - automatic operation...
  18. D

    Macro For Reminder Notification in Outlook From Excel Data

    Need help for the below I am having the data in the excel with the columns as below 1. Event Name 2. Frequency of notification ( Daily or for specific days) 3. Dates from 1 to 31 ( in which date notification required I will fill that cell with "Y") 4. Time to be notified As per this data...
  19. Jonmo1

    Disable email notifications for new Post Thanks/Quotes/Likes feature

    I can't find how to disable the notifications for the new Thanks / Quotes / Likes feature. Particularly the email notifications. I can live with the notification area in the web browser. But I don't want the emails.
  20. N

    Barcode Notification System

    Hi all, I work for a small manufacturing company, and I have been tasked with setting up a barcode system. I am not trying to setup an inventory management system, I do not need to keep track of any quantities (or at least as of right now). I could see the system wanting to be expanded into...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back