Thread: MsgBox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lawson Lawson is offline
external usenet poster
 
Posts: 15
Default MsgBox

rather than tinker around for hours trying to figure how
to get this expression to work, i was hoping that someone
with more experience could show me how its done. I want
the message to say "Found files blah blah blah...:" then
list each file it found below, each file found getting
its own line in the msgbox. my method below has multiple
syntax errors that i havnt been able to get around:

MsgBox("Found File '" & .Filename & "' with "
& .FoundFiles.Count & " file(s) in it." & Chr(10) & _
For i = 1 To .FoundFiles.Count
.FoundFiles (i) & Chr(10)
Next i & _
Chr(10) & "Would you like to save in the file?",
vbYesNoCancel + vbExclamation, "Existing File Found")