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

2.3k Views Asked by At

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

1

There are 1 best solutions below

0
On BEST ANSWER

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