Hello all

I am new to VB macros in XL.

I am writing a macro to achieve the following.

If any changes take place to this document, I want to ask user €œDoes he wants
to send a mail?€�

I am using the following command to ask this question.

Res = MsgBox("This file is modified today" & vbCrLf & "Do you want to send a
mail ??? ", vbYesNo + vbQuestion, "Legal Document")

If Res = 6 Then (means, user clicked YES button)

I want to provide user a message box with a list of mail ids and check boxes
against each mail id to tick the mail ids he wants to send mail and then
click €œSend€� button. Is it possible with the MsgBox command I used as above???
What are the other possible ways???

End If

Thanks
Sri