Option window in macros

[sbmr]

Years ago I managed to write a macro in excel that brought up a window with
a yes or no option. I have forgotton how I did that and do not have the said
file anymore.
What is that window called so I can look it up in the help?

[GS]

Hi sbmr,

I believe what you're looking for is: msgbox.

Regards,
GS

"sbmr" wrote:

> Years ago I managed to write a macro in excel that brought up a window with
> a yes or no option. I have forgotton how I did that and do not have the said
> file anymore.
> What is that window called so I can look it up in the help?
>

[Chip Pearson]

Try

Dim Res As Long
Res = MsgBox("Are you sure?", vbYesNo, "Title")
If Res = vbYes Then
' user clicked yes
Else
' user clicked no
End If



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"sbmr" <[email protected]> wrote in message
news:[email protected]...
> Years ago I managed to write a macro in excel that brought up
> a window with
> a yes or no option. I have forgotton how I did that and do not
> have the said
> file anymore.
> What is that window called so I can look it up in the help?
>

[sbmr]

Thank you, that was what I was after.

"Chip Pearson" wrote:

> Try
>
> Dim Res As Long
> Res = MsgBox("Are you sure?", vbYesNo, "Title")
> If Res = vbYes Then
> ' user clicked yes
> Else
> ' user clicked no
> End If
>
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
> "sbmr" <[email protected]> wrote in message
> news:[email protected]...
> > Years ago I managed to write a macro in excel that brought up
> > a window with
> > a yes or no option. I have forgotton how I did that and do not
> > have the said
> > file anymore.
> > What is that window called so I can look it up in the help?
> >
>
>
>

[sbmr]

Thanks.

"GS" wrote:

> Hi sbmr,
>
> I believe what you're looking for is: msgbox.
>
> Regards,
> GS
>
> "sbmr" wrote:
>
> > Years ago I managed to write a macro in excel that brought up a window with
> > a yes or no option. I have forgotton how I did that and do not have the said
> > file anymore.
> > What is that window called so I can look it up in the help?
> >