message box code

  1. Rob_010101

    Add message box

    Hello, The below macro currently works perfectly and moves a line of data based on the selection from a drop-down menu (data validation list). I'd like to add a simple "are you sure you want to proceed" "yes" "no" style button message box when the user selects the item. Private Sub...
  2. J

    Message box that multiples column based on user input

    Hi, I would like to create a pop up window that displays the message," how many days would you like to accrue for _ out of _ days"? The_ would be user input as to which excel then 1. Divides the values inputted **for instance how many days would you like to accrue for 3 out of 7 days = .43...
  3. V

    Need help for VBA/Macro please!

    Good morning all, I'm having some difficulty with setting up a macro which will trigger if two conditions are met in a worksheet. Require a message box to appear if the value in a particular cell (D4) in the D column shows the keyword “Supplier” and if the value in a different cell (H7) in...
  4. 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...
  5. B

    VBA Message Box

    HI, I want a message box to automatically appear conditional on a checklist being completed. I am currently using Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("B3").Value = 0 Then MsgBox "Checklist Completed- When XXXXX" End If End Sub B3 contains a countif, i.e...
  6. T

    Message Box VBA: Multiple Criteria

    Hello - I am trying to figure out how to create a message box that appears based on multiple criteria. I have tried doing research and still can not figure it out. I know minimal VBA, though I am confident it is possible. I currently have a workbook that my project manager enters his crews...
  7. 1

    Duplicates message with explicit cell value

    Hi, I have a sheet that I use for tracking invoices and have written VBA to highlight if an invoice with the same number has already been entered in column K as follows: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 11 Then If...
  8. K

    display message box when cell color is red

    I have a cell with conditional formatting to turn red when a certain condition is met. is there a VBA code that will display a message box stating duplicate based on a cell color? so what I need is when a cell turns red, a message box to appear showing duplicate. here is the code I have but it...
  9. A

    VBA Code for Message Box

    Hi, I have a workbook where they will be either a YES or NO Value in columns E, F or G. There will mostly be all NO values, but if there is a YES, i would like a message box to pop up and say "There is a negative fund, investment, or source!". This is what i'm using now, but the message box...
  10. S

    Message Box VBA

    I am trying to get a message box to fire automatically based on a cell value. Here is the setup: I have a "configurator" tab (Sheet 2) that has an ActiveX drop down box with a list of names that corresponds to a table of names/job titles on a logic tab (Sheet 3). When you select your name on...
  11. V

    Need cells to lock until a comment is added in the comment cell then unprotect sheet

    I am new to visual basic and need some help with some coding. I have a excel template that has an plan end date and actual end date (2 separate columns) if my actual end date is greater then my plan end date, I need a message box to explain they need to write a comment. If there is no comment...
  12. T

    Vacation Time Error VBA Code

    Hello Everyone, I currently have a worksheet that will populate days with the initials of the Staff that has been assigned a task that begins and ends in a certain time frame. I've used an IF function for this. I now have another task I must do. My boss wants there to be an Error Message...
  13. C

    BeforeClose optional message box

    I have a workbook setup to not close if certain cell(s) are not filled out to prevent error (code below). However, it has become rather annoying if we need to open a sheet just for reference as we have to fill in all of the cells to before excel will close. Instead of preventing the worksheet to...
  14. S

    Multiple variables in MsgBox

    Hi There, I am trying to get a pop up message box to display a list of names that may change each time you open the sheet. I deal with new starters at work and want to have a popup box that finds the users who are starting in the next 2 weeks and haven't already been assigned a laptop. I have...
  15. B

    Create a list in a message box

    Hi, I am trying to create a msgbox that has a list of items. I have values in a column E. If the value in this column is greater than 1 I would like to take the information from columns B, C, D of the same row. There might be no lines where the value is greater than 1 and there might be more...
  16. D

    VBA to auto close msgbox or not!?!

    Hi All, I'm trying to automate a report in Excel 2010 and have got everything working expect for one small problem. Whenever I open the report, it runs the code (which is what I want but bear with me). I would like to have the workbook automatically open (occurring from Time Scheduler) then...
  17. C

    VBA MsgBox - Excel 2010

    I have a macro that runs and throughout the macro the user is presented with several vbYesNo message boxes. However, when they make their choice on each one, each message box stays displayed on this screen. Once they pick Yes or No (or Cancel), I would like the message box to go away and the...
  18. G

    Message Box Help Please :)

    Hi, I need help and I hope someone is clever enough to un-jumble what I've written below and then help me sort out what I need :) I've created a time sheet for my work. Within the time sheet I have created an IF formula to work out how many hours the person is supposed to work each day so that...
  19. C

    MsgBox, Retry or Cancel

    I have a userform that has the user input a worksheet name, which I wave to the variable BorName. I have one IF statement to find out if the worksheet already exists. If it does exists then I want a messagebox thrown and want it to retry or cancel. The second IF statement just allows the sheet...
  20. already

    Formatting % in vbea messagebox

    Hi I have to put the results of a percent calculation (A3) in a message box in format '00.00 %' I use the following code but I can't format the decimal places to only 2 digits Worksheets("Sheet1").Range("A3") & Format(" %", "0.00") Thanks in advance for your help. Kind regards Al

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
Back
Top