Hi all, Can I call a message box from a module? If so, how?
T Tim Ferguson Oct 10, 2006 #2 Can I call a message box from a module? Click to expand... No; you call it from a procedure within a module. If so, how? Click to expand... Option Explicit Public sub Hello MsgBox "Hello, world" End Sub Hope that helps Tim F
Can I call a message box from a module? Click to expand... No; you call it from a procedure within a module. If so, how? Click to expand... Option Explicit Public sub Hello MsgBox "Hello, world" End Sub Hope that helps Tim F
J John Spencer Oct 10, 2006 #3 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")
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")
G Guest Oct 10, 2006 #5 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 John Spencer said: 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") Click to expand...
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 John Spencer said: 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") Click to expand...
J John Spencer Oct 11, 2006 #6 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. Emma Aumack said: If I had an if statement where I had to trap the response would it look like: If iResponse = vbyes or if iResponse = true Click to expand...
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. Emma Aumack said: If I had an if statement where I had to trap the response would it look like: If iResponse = vbyes or if iResponse = true Click to expand...