View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
N E Body N E Body is offline
external usenet poster
 
Posts: 34
Default Declare variable as what?

TNX Myrna


"Myrna Larson" wrote in message
...
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