View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Lav Lav is offline
external usenet poster
 
Posts: 8
Default Using vbYes or If statement

The line that changes is part of a Set WB = Workbooks.Add C:...
this is a workbook that considers an email list.

This is used to send emails.

I had thought of using the msgbox with vbYes and vbNo but I need 3
options, not 2. Hence the If crtieria, seems a better option.

The trouble is the 'Set' issue as it is not a piece of code that I
thought does anything, it needs to be part of something else.

Yes calling up a different macro I don't feel is handy as I don't wish
to tweak three lots of code, I'd rather tweak the one set, as apart
from one line the macros are all the same.