View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Richard is offline
external usenet poster
 
Posts: 709
Default MsgBox, VBYes, VBNo

Help with creationg a MsgBox with VBYes and VBNo, then putting a 1 or 0 in
Sheet4, cell C4. Probably putting the code in Workbook Open?
Example:If date is =July1 and <July 5 then Msgbox "Do you qualify for Bank
Day? If VBYes is selected then a 1 is sent to Sheet4 cell C4, If VBNo then a
0 is sent to Sheet4 cell C4. I just can't write the code correctly.
Thanks in advance