View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Miree Miree is offline
external usenet poster
 
Posts: 90
Default Yes No box no working properly

I have a section of code which brings up the meassage box
but it doesnt matter what i select it always shows Results saved, Can
someone show me how to fix this so that if i select no it exits the sub and
shows Results NOT saved

Response = MsgBox("Do All results have a Formulation Number", vbYesNo)
??If Response = "" Then MsgBox ("Results NOT saved")

ResultsDatabase1
ResultsDatabase2

MsgBox ("Results saved")

Thanks