Call msbox from a module

[Emma Aumack]

Hi all,

Can I call a message box from a module? If so, how?

 

[Tim Ferguson]

Can I call a message box from a module?

No; you call it from a procedure within a module.

If so, how?

Option Explicit
Public sub Hello
MsgBox "Hello, world"
End Sub


Hope that helps


Tim F

 

[John Spencer]

Simplest code

Msgbox "This is a message",,"This is the Title"

If you want to trap the answer

Dim iResponse as integer

iResponse = Msgbox("This is a message", vbYesNo,"Answer the question")

 

[Emma Aumack]

Okay, so the call would be "Hello"?

 

[Emma Aumack]

If I had an if statement where I had to trap the response would it look like:

If iResponse = vbyes

or

if iResponse = true
--
www.bardpv.com
Tempe, Arizona

Simplest code

Msgbox "This is a message",,"This is the Title"

If you want to trap the answer

Dim iResponse as integer

iResponse = Msgbox("This is a message", vbYesNo,"Answer the question")

 

[John Spencer]

Yes, I could have expanded on the suggestion. I chose not to because the
poster had not given any specifics on what they needed to do.

If I had an if statement where I had to trap the response would it look
like:

If iResponse = vbyes

or

if iResponse = true

 

[Tim Ferguson]

Okay, so the call would be "Hello"?

Yup.

Tim F