Long. vbYes and vbNo are long integer constants.

On Wed, 27 Oct 2004 23:20:36 +0100, "N E Body"
wrote:

Hello

Could someone advise me as what the following should be declared as?

Ans = MsgBox("If boxes are empty you will wipe out the list - continue?",
vbYesNo, "Caution")
If Ans = vbNo Then Exit Sub

TIA

Kenny