How to deactivate msgbox in a sub VBA?

Question

Sub prelim()
    MsgboX "Hello World"
End Sub


Sub Main()
    Call prelim
End Sub

In the above code Sub prelim can't be edited.I want msgbox when I run Sub prelim but when I run Sub Main I don't want the message box to get popped out. How to do it?

`Application.DisplayAlerts = False` ‘Your code here` `Application.ScreenUpdating = True` — Abhinav Rawat, Sep 08 '17 at 11:36
Tried it.But it works only outside sub. When I run prelim I need msgbox get prompted.But when I run main I dont need msgbox. :/ — Kosmo, Sep 08 '17 at 11:38

Pᴇʜ · Accepted Answer · 2017-09-08T12:24:21.733

6

This is not possible without changing Sub prelim

Sub prelim(Optional silent As Boolean = True)
    If Not silent Then MsgBox "Hello World"
End Sub


Sub Main()
    prelim True   'no msgbox
    prelim False  'with msgbox
    prelim        'no msgbx
End Sub

edited Sep 08 '17 at 12:24

answered Sep 08 '17 at 11:44

Pᴇʜ

56,719
10
49
73

Worth noting that the `Call` keyword is no longer used. While it will compile fine, it is preferred to just do `prelim True` or `prelim` – Brandon Barney Sep 08 '17 at 12:23
@BrandonBarney Of course you are right! `Call` is deprecated. I changed that. – Pᴇʜ Sep 08 '17 at 12:25

How to deactivate msgbox in a sub VBA?

1 Answers1

Linked