message box

Hi Everyone, Im trying to have a message box state how much someone has overspent by, which works.. but it specifies that everyone has overspent (overspending by -£200), meaning that it opens a MsgBox for each person specified in the document (opening 18 MsgBox's in total). Is there any way i...

If you have a list box on a user form and the user doesn't make a selection it will display message with VbYesNO. if the user then click VbYes then the macro stop and allows the users to make a section/s without closing the user form or if VbNo then Exit the sub This is run with a command button...

I am creating a personal finance tracker where a user enters their purchase information in order to track their daily/weekly/yearly spending. Upon submitting the User Form, the information simply populates a raw data source that feeds into many pivot tables and charts. For my own personal...

I have searched and searched, but not found an answer to this: I have a workbook that is shared by users, and needs to be auto-closed after 10 minutes of inactivity. The VBA code to close the workbook if no changes have been made in 10 min works OK. However, I want to give a user who has been...

I am having a problem with getting a message box to open and close when I need them to. lets say text box 1, 2, 3, 4, 5, all have to have something entered in the fields when I click the Submit button. If they do not have something in the field then I want a message box to pop up saying the...

Hello All, I think not using Excel for so long has dimmed my skills, For whatever reason, I cannot figure out why I am having problems with making these message boxes appear in Excel. Here is what I have: Sub goprompttest()Dim OutPut As Integer If Range("E44").Value = 0 Then...

I'm currently using the loop: For i = 1 To 10 Application.Workbooks.Open ( files(i) ) Next To open several excel workbooks. It works fine, but the standard message "File in Use" message box doesn't display, and the files just open in Read-Only mode without warning. Is there any...

Greetings, I have a macro (which runs painfully slow) that highlights unique cells between two ranges on different worksheets. I've been trying to add a message box that displays the number of unique cells but the method below has not been working: Sub HighlightDuplicates()...

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

After this message comes up I need time to check if problems and fix before macro continues Sub A1MESSAGE() ' ' A1MESSAGE Macro ' ' Application.Goto Reference:="R1C1" Dim save As Integer output = MsgBox("MAKE SURE THERE IS NOT A DR & CR ON SAME LINE, IF SO NET OUT"...

Morning I use the below Macro for an annual leave tracker.... if it sees 0 it gives a pop up message, however it seems to have an issue that it sometimes give an error when the minimum number is 5 or 3 and on other rows if it's 0 (correctly) I have tried tweaking it but have had no success -...

Good afternoon gentleman's. I have created the following script to run different messages based on the result of a formula on the worksheet. My problem is that I have implemented the vbYes/Vbno message box on one selection to change the value of a cell if the user clicks "Yes. This is performed...

Hi everyone, I would like to have a message box to appear when Excel workbook is open. The message is to let the user to "Fill in only highlighted cells" because the remaining cells will be password protected so they don't freak out when trying to fill in un-highlighted cell and it does not...

Hello! I have a macro that asks the user through a message box to accept or reject the changes made by the macro. However, the excel sheet that needs to be reviewed to accept or reject those changes is fairly large and the user cannot see all the changes without scrolling though the page...

Here's the Vb Code I used but I keep getting a "Argument Not Optional" message box. I want for the macro to run if the value equals to "Iawn I Bwcio". But if the value equals to "Dyddiad Anghywir" then I want a message box to appear and say ; "Mae yna dyddiad anghywir wedi ei fewnbynnu! Mae...

Hello everyone, My first time posting on this forum so please excuse any mistakes I make. I have created a macro button to move from one sheet to another in an excel document but I want also want the button to check to see if multiple ranges of cells have values, if they don't then pop up a...

Hi, and thanks for taking the time to view this post. I am running the following code to create 20 or thirty message boxes that activate when particular cells are clicked. Essentially, I need to provide the user information related to specific cell entries. My problem is when the user selects...

Hi I am trying to use VBA to produce a series of message boxes depending on the response to each one. The whole series is based on a value in A1 and a comment that the user has put in B1 This is a description of the type of thing I want to do: If value in cell A1 = 0 Then Bring up message...

Hello all, I seem to be having an error, I am running code that loops through column AR, checks for a value and if the value is present, copy and paste the row to a corresponding sheet. I am using the Resize function to define how many cells of the row I wish to copy. However, for some reason...

Hi This is a bit complex for me. I am trying to do a VBA on an excel data sheet. On this data sheet, in column E there are amounts and in column F there is either "C" (for Credit) or "D" (for debit) against the amount. So if you see the below example I have copies, 50000 D is for debit. What...