Declare variable as what?

[N E Body]

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

 

[Myrna Larson]

Long. vbYes and vbNo are long integer constants.

 

[Bob Phillips]

as Long

 

[Trevor Shuttleworth]

Kenny

Dim Ans As Integer

Regards

Trevor

 

[N E Body]

TNX Myrna

Long. vbYes and vbNo are long integer constants.

 

[RB Smissaert]

Also you can do it like this, without declaring a variable:

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

RBS

 

[Rob Bovey]

You can also declare it as VbMsgBoxResult and it will give you an
auto-complete list of allowable values when you press the equals sign.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *