msg box

  1. U

    VBA Message Box for conditional formatting

    Hi, I have a spreadsheet with columns G-J setup with conditional formatting based on dates. the cell will change to yellow if the expiration is 60 days out, and will turn red if the expiration date is 30 days or less. I would like to setup a vba code that will give me a pop-up message upon...
  2. U

    VBA pop-up message box for dates

    I am have a spreadsheet that I would like to get a pop-up msg box on upcoming expiration dates upon opening the workbook . My spreadsheet is like this: Column A - Driver Name Column F-I - Have various different expiration dates Sseveral columns beyond, with other driver information I am trying...
  3. F

    Counting Multiple instances

    Hello, I'm trying to figure out the code for counting multiple instances of different text in a column and displaying it all under one msgbox as a summary. So far I have only been able to get one count going with the below code; However I want it to check for 6 different colors count how...
  4. G

    VBA Data validation with location of errors

    I have this workbook that has columns A through E with information. For column A, I was looking for a VBA that will compare the current data in the cell (starts at A2) until the end of data, to see if it matches with data in ("Sheet2") range would be G2 until the end of data. This will go...
  5. M

    VBA Message Box with 4 messages

    Hi I'd like to create a MsgBox that evaluates 4 conditions, please: If cells E1 and K1 are BOTH equal to zero, then it will say "All good." If cell E1 is NOT equal to zero, it will say "Check your supplier data" If cell K1 is NOT equal to zero, it will say "Check your location data" If...
  6. I

    How to have a message box appear if referenced workbook name is not correct?

    Hello. I made a long macro for myself and coworkers that references one static workbook multiple times. However, I have to edit the coding behind it once in a while and resend it. When this happens they are told to delete the others and make sure the name is the same. However, some are not tech...
  7. M

    Pop up messagebox every Monday

    HI , How can I do pop up message" do xyz " in excel every monday ?
  8. R

    VBA error message that notes row number

    Hey all, I had a VBA code that was working. It would look for an error condition when Ledger = ABC and Company = V3 and would prompt a message box advising the user "Error on row 20". They now want to look for company V3 or V4 so I changed the IF into a Case to look for multiple items and...
  9. R

    MsgBox Help

    Hey all, Thanks for your time in helping me. I have a list of names populating each row in column A In each row there are dates corresponding to the name in column A Some names have zero dates, some names have up to forty dates Example: name1 date1 date2 date3 name2 name3 date4 date5...
  10. A

    Msg Box Userform

    Hi Everyone, Hope all are fine. I have very basic knowledge about the VBA and looking out for some help. I have a combo box in excel userform (cmboxabc), which is depend on multiple options buttons and one textbox value. I want if all options buttons are unchecked and textbox value is blank...
  11. M

    MsgBox Prompt Variable

    I'm trying to make the value of a textbox become dynamically inserted into a message box. In the code below, I want NAME replaced with Me.TextBox2.Value. MsgValue = MsgBox("Are NAME's documents filed?", vbYesNo, "Training Documents") Thanks!
  12. D

    Msgbox based on cell value/text

    Hi simple one I think. I am trying to have a pop up msgbox appear if a cells value = yes. any help please.
  13. S

    Limit message from MsgBox only to when related cells change (not any cell))

    Hello, everyone. This is my first post! And I'm also brand spanking new to VBA, so bear with me. First, I'll explain what I'm trying to do. I manage a work order system in Excel and I want to pop up a message to the users inputting new work requests that alerts them if their requested...
  14. L

    MsgBox when user attempts to copy/paste

    Hello and thanks for your time. [I am using Microsoft Office 2013] I have prevented users from copying/pasting within a worksheet with the following VBA code (found online): Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.CutCopyMode = False...
  15. C

    run-time error 91 on Msg Box Code

    Hi all. I hope you can help I have a piece of code that is producing a run time error 91 I am trying to get a MsgBox to tell me if there is a sheet in my workbook called "In Progress" or else that is not in my workbook but it is creating an error on this line If = "In...
  16. J

    Auto run Macro on Startup Conflict

    This is my first time posting on the forum, so I want to go ahead and thank you all for the support that you have given me so far. I am very new to VBA & Macros, so if my question seems silly, I apologize. I have tried researching this, but I cannot find an answer. Here is what I have: I am...
  17. P

    Excel VBA code question regarding Message Box

    Hi, I've got a question regarding VBA coding and the message box functions. currently I've got a string of information (where the goal is not to have a message, all messages displayed are error messages). However if my string is empty/blank (so no errors) is there a way to say "no error...
  18. B

    Can you restric when a macro is able to run

    so if there is a date that is defined in range a1 that is within 48hrs then the macro wont run? and offers a MsgBox instead? many thanks jamie
  19. J

    Object not found from inputbox; need to handle error

    My input box fills the inboxfldr in this code Set Fldr = olNs.GetDefaultFolder(olFolderInbox).Folders(inboxfldr). If the object isn't found the vba gives a run time error. I want to suppress that error, prompt a message box that folder isn't found and just re-promt my inputbox. Looking for some...
  20. A

    Error/Msg Box to appear if Cells dont match

    Hi All, I have a sheet where employees submit weekly activity figures. They enter figures in section A and Section B where the totals are in Cell A25 and A60. At the end they then click a button (in a macro called "Submit")to submit the figures. What i want is a message or error box to pop up...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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