1. G

    print msgbox on new sheet

    I'm looking for VBA that if the person selects yes, the information that was in the message box will be pasted into another sheet that is created. A1 will say "Type" B1 will say "name", A2 and down will have the information from sheet1.Range("b" & VNR). B2 and down will have the information from...
  2. G

    Message box List

    I have been searching with no avail on a vba to display a msgbox with specific data. I have an idea but the specific throw me off (still a beginner). This message box will display a value1 then tab then value2 then tab value3 then new line value1-2, tab value 2-2, tab value 3-2 and so on until...
  3. sycodiz

    VBA MsgBox based on rows - continue if true cancel if false

    I have searched everywhere for this answer. I am sure it is out there but I feel like I am going in circles. So I came here to you awesome people for help and direction! I do apologize that I am not very savvy in VBA but occasionally I do have to create some crude macros and then come to you...
  4. G

    Opening a MSGBox if a word is click in the Comment vba

    I'm not sure this is possible, but I am looking for a VBA to open a Message Box if the word "HERE" is clicked in a comment, this could linked if necessary. The comment is located in cell R4. I'm not sure where to start with this VBA, but I'm sure someone has dealt with this before.
  5. B

    Message box to flag up negative figure

    Hello, Some help with a code please... I have set up the below sheet showing quantities of different items. There is a button (offscreen) that exports this list - I would like to add a message box that, when exporting this list, alerts for any negative figures in the period listed (i.e. in...
  6. M

    msgbox appearing twice

    Hi, I was hoping someone could tell me why my msgbox gets triggered twice? Its in the comboboxchange so my initial guess was because i was making Comboxarea2B.value="" that it was triggering it again but if this is the case then how do I make Comboxarea2B value blank without triggering the code...
  7. J

    Msg Box based on part string

    Hi, I need to search column B for any cell (there will be multiple) that contains 'subtotal' in the string of text (there will be 'Subtotal - Section 1', 'Subtotal - Section 2' etc). Then a message box to pop up asking for the Rev Code1 for that subtotal section and for the Rev Code1 the user...
  8. M

    VBA Vlookup - if part number not found then display Msgbox and Exit Sub

    Hello, I have following macro which on Error will resume to next. Now I want to display a message box if an error is found and after exit SUB Message box( "Part number" & "PN" & "not found. Please define packaging details") By PN should be displayed the part number that is not found. Sub...
  9. C

    "SetWindowsHookEx" Crashing Excel x64

    Hello. For a while I've been using the MsgBoxCB sub from Dan Elgaard ( in order to have message boxes with custom button text. Up until now I have been using Excel 2007-2019 x32 and everything has been working perfectly. Recently I started testing my application on Excel 2016...
  10. S

    VBA: Msgbox to alert that there are no negative values in the final col for validation

    Hi, I am relatively new to VBA so still struggling to fully understand the syntax. I have been working on an automation macro & I am quite close to completion I just have a step that is appearing more difficult than I would've thought. I am trying to provide a pop-up that alerts the user...
  11. B

    Create Custom Msgbox VBA Multiple Criteria

    Hi Everyone, What if I want multiple msgboxs per each sheet? I realize I can have two different outcomes to a specific scenario. Is there a way to use IF, THEN? For instance, if COLUMN L and COLUMN K equaled ONE then I would want a message to say "Burris article, check sourcing", but if COLUMN...
  12. J

    Adding msgbox to code

    Hi, Can anyone help, i am trying to get a msgbox to popup when no id is found. I have a sheet called Info and in column G i have some names and in column H I have some id numbers. I have a userformwith two textboxes when i scan an id into textbox7 that then searches the sheet Info then...
  13. gheyman

    Yes/No Message Box

    I would like to add a pop-up Message box that happens in this code after the DoCmd.RunCommand acCmdSaveRecord. "Do you want to return to the TSL?" If Yes then then DoCmd.OpenForm "frm_NIS_TSL", acNormal, "", "", , acNormal If No then the DoCmd.GoToRecord , "", acNewRec command Any help is...
  14. T

    Checking fields null

    Private Sub Command228_Click() 'Save On Error GoTo Command228_Click_Err On Error Resume Next DoCmd.RunCommand acCmdSaveRecord If (MacroError <> 0) Then Beep MsgBox MacroError.Description, vbOKOnly, "" End If Command228_Click_Exit: Exit Sub...
  15. L

    range.interior.color - value

    Hi What is the maximum value that color can take? I wrote the code below. Can I say the min value is 0 which is the value of rgb(0,0,0) and max value is 16777215 which is the value of rgb(255,255,255) Can I say that? Thank you very much. Sub myrgb() MsgBox RGB(0, 0, 0) MsgBox RGB(255...
  16. K

    Can someone help me with my coding to return error box only one time and also to create msgbox as Critical?

    Hello, I am attempting to create an error message msgbox in an Excel workbook/worksheet. I have the coding to create the msgbox but if the error is on the worksheet multiple times, it shows the error multiple times. I have tried using alreadyprompted coding to stop this action but I'm having...
  17. I

    Slight edit to existing working code

    Hi, The code in use is shown below. This is how it works. I have a listbox with customers names. I select a name & when i press the DateTransferButton todays date then is entered into the cell for this customer at colomn G I believe at present if a value is in the G cell then i see a message...
  18. G

    Finding Multiple Shapes

    I can't find the 2nd or 3rd Shape I'm want to edit. It locates the 1st one, but not the 2nd or 3rd. I used "record macro" to select the shapes and get the name. Sub PleaseFind() ActiveSheet.Shapes("Rectangle 9").Select ActiveSheet.Shapes("Rectangle 5").Select ActiveSheet.Shapes("Rectangle...
  19. D

    VLookup not working in VBA

    Hello, I'm attempting to do a VLookup in a macro while using the Match function to dynamically determine which column to look in. I did some testing by sending values to a Msgbox to validate I am passing the correct values. Ex: MsgBox "Match Value is : " & Match1 <== the value was 13...
  20. kelly mort

    Get last folder vba

    When I remove the last slash from the path FullPath = ThisWorkBook.Path & "\MyFolder" It works fine to display "MyFolder". But when I place it back as below, it shows blank. How do I fix that? Because I need that last slash in my path. Thanks Sub GetLastFolder() FullPath =...

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