msg

  1. I

    Close form upon msg OK click

    Hi, The code below has a message that pops up saying Msg = "CHANGES SAVED SUCCESSFULLY" It has OK on it & when i click it the message closes & i am then back to the form. Please can you advise how when i click OK not only does the message box close but also the form. A separate button on the...
  2. S

    status not being transferred to sub routine

    I have a form that prompts the user to continue or cancel. If they select the wrong file I cancel and want to give a message and restart. I need to check myFileStatus As Boolean but it is empty when I return to Public Sub OKButton_Click(). Your help is appreciated. Tom ' located in...
  3. O

    Open saved Message msg and replace subject

    I have several directories with saved OUTLOOK .msg templates. I have a spreadsheet with column A with saved paths to each file, and in column B, a subject line that I would like to replace the subject line with. I would like to be able to click a button in "sheet 1" and it would open the msg...
  4. E

    MSG files

    Operating System: Microsoft XP Applications: Excel 2007 Outlook 2007 I am trying to write a macro that would extract the data from selected msg file(s) within a folder and paste the data in to the next available row. I already have an existing workbook with data on it. It should look like...
  5. J

    Display Array in MsgBox

    Hello, I have an array of data that is calculated in a macro that is named myarray. The length of the array can vary depending on the data. I was wondering if there is anyway to display each element of the array in a message box. Thank you, Jared
  6. C

    VBA - Move MSG files into Outlook

    Hi all I need to write a bit of VBA to move msg files from a disk location into Outlook. Once I have moved them into Outlook I then have to read the list of recipients from the email to process into a database. I am fine with the reading the names once I have the email in out look but I am...
  7. J

    Msg Box based on a sum and another cell

    Hi I want to be have a msg box pop up when the sum of a set of cells (range1) is more than the sum of another set of cells (range2). If range 1 > range 2 is true, then it needs to check a cell (A12) is not blank. If the cell is not blank, do nothing, if the cell is blank then pop up a message...
  8. S

    Problem with msg box

    I have this formula That works MsgBox (Range("B6")) If i try and add the title like this. MsgBox (Range("B6"),vbokonly, "Question") I get a compile error can you help? Thanks

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