Change Answer in function MsgBox

[Affa]

Good Morning,


I have a problem with the Msgbox function.
I need to create a Msgbox function in wich the user can choose between two differents options, that aren't the standard answers Yes/No; the different options for my Msgbox must be excel/csv.
Cuold you help me?
This is the vba code that i have used:
Answer = MsgBox("Choose the format of saving file", vbQuestion + vbYesNo, "Input Box")
....

Thank you very much

Alternatively can you suggest me the best way for insert in a macro a function in which the user can choose if he wants to export a query from access 2007 in excel or csv???

 

[gemma-the-husky]

the standard msgbox functions just offer things like yes/no/cancel

you would have to devise a your own form with your own custom options. There are numerous examples on here.

 

[darbid]

I need to create a Msgbox function in wich the user can choose between two differents options, that aren't the standard answers Yes/No; the different options for my Msgbox must be excel/csv.
Cuold you help me?

Here is one I wrote http://www.access-programmers.co.uk/forums/showthread.php?t=198190&highlight=iCandy

I played the form size, shape and shadow with the Windows API which is not a great success with every Operating System, but you would get the idea of how to do what you want.