Execute Multiple Lines in the Immediate Window of an Excel VBA workbook

Asked 19/9, 2018 at 17:17 Answered 19/9, 2018 at 17:17

Am I limited to execute only 1 command in the Excel VBA Immediate Window. Is there a way to execute multiple statements?

Posticous answered 19/9, 2018 at 17:17 Comment(0)

Use the colon : key to concatenate multiple statements together. (ex: MsgBox "msgBox1" : MsgBox "msgBox2" will display two alert message boxes.

Posticous answered 19/9, 2018 at 17:17 Comment(0)