Easy VBA Syntax Question

[Hulk]

I have a macro that pauses for a user response. A dialog box comes u
saying "The selection contains multiple data values. Merging into on
cell will keep the upper-left most data only." At this point, I can hi
OK and it will continue.

How can I automate this so it automatically selects OK?

Thank you

 

[kkknie]

Place the following around your code that does the merge:

Application.DisplayAlerts = False

'Your Code

Application.DisplayAlerts = True

 

[Don Cossitt]

I think this is how it works...

MsgBox "This is default button",vbYesNo + vbDefaultButton2,"Try It N See"

vbDefaultButton2 designates the second button (NO) as the default button.

doco

 

[Don Cossitt]

oops! Misunderstood the question ... sorry.

I think this is how it works...

MsgBox "This is default button",vbYesNo + vbDefaultButton2,"Try It N See"

vbDefaultButton2 designates the second button (NO) as the default button.

doco

 

[Bob Phillips]

If you want it to automatically select OK, why have the dialog box at all?