msgbox with 3 options

[gstylianou]

Hello everybody and Happy New Year,




I would like to have your help on a seemingly simple question. I have a form in which is embedded a cmdButton. I want "on-click" to gives a simple message (eg. "abcd") with 3 options: a) On-Cancel to close the base, b) On-Open A" to open the form A, and c) On-Open B" to open the form B.


I Would appreciate any help.


Happy New Year 2014 again and thanks in advance


Sincerely,


George

[amrut]

Msgbox does not support custom captions for buttons. See http://msdn.microsoft.com/en-us/libr.../gg251821.aspx
You may use an input box instead listing out the three choices and asking user to enter a,b or c based on their choice.

[gstylianou]

Hello my friend "amrut",

Because I'm not experienced in vba could you please give me an example so that I can figure how can i do it;

Thanks again,

Regards,

George

[amrut]

Search for Inputbox in help.
Here is one example

Private Sub Command1_Click()
Dim yourChoice As String
yourChoice = InputBox("Enter your choice " & vbNewLine & "a for Choice one" & vbNewLine & "b for Choice two" & vbNewLine & "c for Choice three", "Select option")
Select Case yourChoice
Case "a"
MsgBox "User selected a"
Case "b"
MsgBox "User selected b"
Case "c"
MsgBox "User selected c"
Case Else
MsgBox "Invalid choice"
End Select

End Sub

[gstylianou]

Hi again,

thank you very much for your help my friend. I would try the code and i will be back.

thanks again