CODEWITHSUNDEEP
vbaexcel
demonLaMagra
demonLaMagra

Reputation: 409

VBA - Accessing message box attributes

I'm writing a macro that will run a set of other macros at the start of every month. However these 'other' macros contain message boxes that will need to be accepted.

Is there a way for the macro I am writing to accept these?

Upvotes: 0

Views: 71

Answers (1)

manu
manu

Reputation: 942

You could use Application.SendKeys ("~")

Example:

Sub test()

Application.SendKeys ("~")
Call message
Range("A1").Value = 1

End Sub


Sub message()
MsgBox "Choose", vbYesNo
End Sub

Upvotes: 3

Related Questions