View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Declare variable as what?

Kenny

Dim Ans As Integer

Regards

Trevor


"N E Body" wrote in message
...
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