messagebox

  1. T

    Macro to open two XLSM files from Names and Filepaths in cell

    Hi Everyone, I want to be able to open two XLSM doc from a folder. The Two File Names are in sheet "Welcome" Cells "B11" and "B12" but don't or might not have the .xlsm ending. the filepath is in cell B10 and will look like this "C:\Users\Tonypc\Downloads\New folder" I would like to first...
  2. T

    Display contents of array in messagebox

    How can I display the contents of an array in a messagebox? This fails on the MsgBox line. Dim MyArray(1 To 3, 1 To 1) As Variant MyArray(1, 1) = 1 MyArray(2, 1) = 2 MyArray(3, 1) = 3 MsgBox MyArray Thanks
  3. A

    messagebox to prompt another messagebox

    I am having a difficult time figuring out how to have a yes/no messagebox selection open another yes/no messagebox. Is this not possible and I need to use a userform?
  4. B

    VBA preventing adding a name to a list if the name is already in the list

    I use the following code to enter a name selected from a listbox to the end of a list of names named "nameList" I please need some help to prevent the name being added if it already appears in the list and a messagebox to appear advising that the name was not added because it is already in the...
  5. A

    Messagebox with date and last updated by information

    I'm pretty sure this can be done in VB, but I'm just starting to dabble in VB - so here it goes: When a file is open, I'd like to have a messagebox display the message, "File [filename] was last update by NAME on DATE" I'm assuming VB would be the place to do this? Has anyone done something...
  6. T

    vba to check if any of checkboxes are ticked

    Hi Everyone, I have a set of checkboxes there names are CheckBox21 to 30 I just need a macro that if none of the boxes are checked I get a messagebox saying "please select one" how can I do this? Thanks Tony
  7. A

    Cannot run the macro "macroname". The macro may not be available in this workbook or all macros may be disabled

    I need help. I am lost. My other workbook with the same data but from last year works fine with the buttons I made. This new workbook does not work. All macros are enabled under Trust Settings. I tried creating just a new button with a messagebox and this still comes up. When I debug and hit the...
  8. J

    Error on forms

    Hi guys, I have a userform and sometimes if you don't input a value in one of the textboxes, you get and error. I want that when there's an error, a messagebox will disply "Please fill in the missing fields" and then go back to the form for the client to continue using it. I tried: On Error...
  9. L

    MessageBox opens multiple times

    Hello everyone! I have a MessageBox in my application that asks whether the user wants to add a new product to the order or not. If I press 'No', it closes. When I press 'Yes', it does what it's supposed to do, lets me add another product, and so on. The problem is that once I press no, the...
  10. V

    VBA Message Box

    I would like to make the combination of UserForm and MessageBox but stuck with the code, can anyone help to rewrite the code correctly? Private Sub CommandButton1_Click() If MsgBox("Are you sure?", vbYesNo) = vbYes Then Dim lRow As Long Dim ws As Worksheet Set ws = Worsheets("Sheet1") lRow...
  11. E

    find empty cell from specific cell ranges and display result in msg box.

    Hi, i have a case where i wanted to find if there is any empty cells in the specific range of cells. if the macro find any empty cell it should show the cell names in message box or the empty cell can be highlighted, if there is no empty cell then"NO EMPTY CELLS FOUND" should be displayed in...
  12. E

    Cannot create MsgBox in VBA

    Hi Does anyone know why I cannot create messagebox in VBA, it seems like I might miss a Library.... Whatever I try to code it ends up With a text in red... Sub basic_messagebox() Answer = MsgBox("Do you wish to be terminated ?", vbYesNo) End Sub Best regards Espen
  13. A

    Find a value in a column and then fill some cells in that row. Everything using InputBox

    Hello MrExcel, excuse me if I make a mistake with the language, because English is not my own. I want to press that command button that pops an InputBox and put a number in it, like the picture. That happens in sheet "Sizes". Then I want that value to be searched in Column A of the sheet...
  14. B

    VBA - How to create Macro that bolds a certain area based off user input

    Hi, I am trying to create a MACRO that based off two different times that the user inputs into a message box will automatically create a thick bold border. For example: <tbody> Line Time Name Age Destination 1 9:15 Chris 21 NV 2 10:15 Janet 22 NY 3 11:15 Lura 34 CA 4 12:15 Matt 52 CO...
  15. S

    Message box if duplicate found and clear the data from corresponding cells

    NEED URGENT HELP! HELLO I have been trying to find a way to get this worked but have been unsuccessful. I am trying to get a pop message when duplicate values are found in Column C which generates a unique code (only numbers) when values in column D,E,F,G,H,I,J,K and L are inserted ( in the...
  16. K

    How to copy entire row to different sheet

    Hi, I have 4 sheet in my excel file, I wish that when column O value in Overall sheet is equal to Ni, it will copy the row to Ni sheet When column O value in Overall sheet is equal to NiAu, it will copy the row to NiAu sheet. When column O value in Overall sheet is equal to NiPd, it will copy...
  17. K

    How to display different message box

    Hi, I wish to display a different message box when it meet the following requirement: 1. When textbox8 value less than 3, message box will show textbox8 is out of range, do user want to continue store the data, if user hit yes, then will continue store the data but if user select no, will ask...
  18. 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...
  19. A

    Macro to goes through each row to find value, if found create a message box

    Hi everyone, I have created a macro that should go through each row of a worksheet and look at two columns for specific values. If these values are in a row, a message box should appear asking to confirm that these details are true. If you click yes, the macro will continue, if you press no...
  20. G

    Excel macro Custom Message box theme

    Hi, I need to change the msgbox,inputbox theme color.. for example : i have 6 msg box i want them to be in white and red color.. Could you please help out.. Thanks in advance

Some videos you may like

This Week's Hot Topics

Top