CODEWITHSUNDEEP
excelvba
user163342
user163342

Reputation: 27

why is this msgbox code popping an error?

i'm trying to make an msgbox with only an OK option, but needs to have description and a title.

MsgBox ("this is where i put my message", vbOKOnly, "this should be the title")

it just gives me an error message when i try to run the code

Upvotes: 0

Views: 35

Answers (1)

Tim Stack
Tim Stack

Reputation: 3248

Lose the parentheses

MsgBox "this is where i put my message", vbOKOnly, "this should be the title"

alternatively, you could do

rspns = MsgBox ("this is where i put my message", vbOKOnly, "this should be the title")

The latter would not be to your benefit though. If you were to use a messagebox from which you want to catch the response (e.g. vbYesNo) that would be a method to use, the response would be stored in the rspns variable.

Upvotes: 1

Related Questions