VBA if specific pop up then close

[dshafique]

Hi everyone, i am working on a macro which populates an input table for BEX analyzer add in. I am using sendkeys method and there is a popup that comes up if the input is wrong.

is there a way for me to make an if statement depending on the title of the alert.
for example:
If popup title = "BEX analyzer"
then send key {Enter}
Send key {enter}
Else
move on

 

[Logit]

If popup title = "BEX analyzer" Then
    send key {Enter}
    Send key {enter}
Else
    Exit Sub
end if

or ...

If popup title = "BEX analyzer" Then
    send key {Enter}
    Send key {enter}
Else
    Call TheNameOfTheSubYouWantToGoTo
end if

 

[dshafique]

If popup title = "BEX analyzer" Then
    send key {Enter}
    Send key {enter}
Else
    Exit Sub
end if

or ...

If popup title = "BEX analyzer" Then
    send key {Enter}
    Send key {enter}
Else
    Call TheNameOfTheSubYouWantToGoTo
end if

Thank you, when I type any of these in, it gives me an error in the "title" part. is there a library I need?

 

[Logit]

I am not familiar.

What specifically is : popup title ?

Please describe.

 

[dshafique]

I am not familiar.

What specifically is : popup title ?

Please describe.

ah, i see. popup title is not a variable. I wanted to know how to perform an action based off what the title of the alert is. for example, if the popup's title bar says "Bex Analyzer" I want the macro to activate the alert box and press "Tab" and "Enter"

if anything else, i want the macro to activate the window and press tab twice and then enter (which will exit out of it)

 

[Logit]

Is the "popup title" the title viewed on a MsgBox notification ?

Or is the "title" belonging to some other piece of software (not Excel) ?

 

[dshafique]

Is the "popup title" the title viewed on a MsgBox notification ?

Or is the "title" belonging to some other piece of software (not Excel) ?

yep, it's the title viewed on the message box notification

 

[Logit]

While a MsgBox is visible, you can press keys CTRL / C. That copies the contents of a MsgBox. You can then press keys CTRL / V. That will paste
what has been copied to the active cell. Practice.

Now, you can write a macro to perform the COPY / PASTE routines. Then, you will need to add code that identifies the second row that was pasted.
The first row will be only dashes.