msg box

  1. 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...
  2. 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...
  3. 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...
  4. M

    Pop up messagebox every Monday

    HI , How can I do pop up message" do xyz " in excel every monday ?
  5. 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...
  6. 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...
  7. 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...
  8. 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!
  9. 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.
  10. 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...
  11. 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...
  12. 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 worksheet.sheet.name = "In...
  13. 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...
  14. 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...
  15. 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
  16. 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...
  17. 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...
  18. A

    Help please, VBA userform, MsgBox() ?

    Hello. I have a userform that I use to introduce some data on Excel. Most of the data must be filled (that are textbox that the verifications dont need the information to do the calculations), because if they are not filled the rest of the Worksheet cant do the verifications that I need...
  19. D

    VBA MsgBox code needed for skipping portion of code

    Good afternoon everyone. I need to put in a pop up box in my VBA code to have it ask the user if they want to do something. They can click Yes or No Yes: continues as normal No: skips a section of the code I did a few tries at this and keep getting an error. I know this is simple. Can...
  20. P

    Changing the color of part of a string

    I am trying to write code which changes the color of text added to a string through an input box. It works great if I only have to add colored text to the cell once, but when I try and add any more information through the input box it resets the color of all the text. What I want to do is keep...

Watch MrExcel Video

This Week's Hot Topics

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 MrExcel.com.
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 "mrexcel.com".
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
Top