if msgbox("Would you like to open file: " & Range("A1").value) = vbYes then
'Open the file...

By the way a message box returns a long, not a string... Not that it matters
with the above code...
--
HTH...

Jim Thomlinson


"EMoe" wrote:


Hello Programmers,

This partial code opens a message box with a question before executing
a code.
Dim t As String
t = MsgBox("Are you sure you want to open the Chemistry sheet?",
vbYesNo)
If t = vbYes Then

How do I write code that pops up a message box like the one above, but
ask if I want to open the file name that is in "Cell A1". The code will
have to grab the file name from "Cell A1", and place it in the message
box.

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=498074