Re: Add a Confirmation Message Box to a macro?

[raymangoose]

Re: Add a Confirmation Message Box to a macro?

I have this code that prints everything from data validation, but I also want to run a massage that says "are you sure you want to continue" before running the code. My code works separately but not with the massage code.

Sub ClearINV()


Answer = MsgBox("Are you sure you want to continue?", vbYesNoCancel + vbInformation, "Application Message")






If Answer = vbYes Then Else Exit Sub


If Answer = vbYes Then Else Exit Sub
 Sub Iterate_Through_data_Validation()
    Dim xRg As Range
    Dim xCell As Range
    Dim xRgVList As Range
    Set xRg = Worksheets("Lease Abstract").Range("I2")
    Set xRgVList = Evaluate(xRg.Validation.Formula1)
    For Each xCell In xRgVList
        xRg = xCell.Value
        ActiveSheet.PrintOut
    Next
End Sub
End If
End Sub

 

[Sushiboy]

Re: Add a Confirmation Message Box to a macro?

Hi, Trying to amend the code to include in the message box details of failed items.

So in the active column, I have some cells indicating "FAILED". in the adjacent columns I have data in Column A and B. How will the below code be amended so it lists the corresponding data in Column A and B when the message box appears??

At the moment it indicates how many failed items in the active column, but I need to add to this and provide details what the failed items are from Column A and B.
Many thanks


Sub Messagebox1() Dim instances As Long instances = WorksheetFunction.CountIf(Columns(ActiveCell.Column), "FAILED") MsgBox "Found " & instances & " Failed Upload(s)", vbInformation, "TITLE"​

End sub

 

[Fluff]

Re: Add a Confirmation Message Box to a macro?

As this question has no relevance to this thread, please start a thread of your own.

 

[Sushiboy]

Re: Add a Confirmation Message Box to a macro?

i dont know how to start a thread

 

[Fluff]

Re: Add a Confirmation Message Box to a macro?

Have a look at step 2 here https://www.mrexcel.com/posting-to-mrexcel-message-board/

 

[Forever_EX]

Re: Add a Confirmation Message Box to a macro?

You are very patient

Have a look at step 2 here https://www.mrexcel.com/posting-to-mrexcel-message-board/