E-M

myVar = Rnd
If myVar <0.5 And myVar .1 Then
MsgBox "Yes"
ElseIf myVar .5 And Rnd < .9 Then
MsgBox "Yahoo"
Else
MsgBox "No"
End If

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"ExcelMonkey " wrote in message
...
I use "IF And" statments in excel alot. But in VBA I dont think you
don't use the brackets with "IF AND". How would your write the
following in VBA?




=IF(AND(RAND()<0.5,RAND()0.1,),"Yes",IF(AND(RAND( )0.5,RAND()<0.9,),"Yahoo"
,"No"))

Note you will have to replace the excel rand() function with the VBA
rnd() function.


---
Message posted from http://www.ExcelForum.com/