VBA Referencing a cell

[EMoe]

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

[Jim Thomlinson]

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
>
>

[JE McGimpsey]

One way:

Dim nResult As Long
nResult = MsgBox( _
Prompt:="Are you sure you want to open file " & _
Range("A1").Text & "?", _
Buttons:=vbYesNo)
If nResult = vbYes Then
'Open the file
Else
'do something else
End If



In article <[email protected]>,
EMoe <[email protected]> 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]

Thanks for the reply. I'm still analyzing the codes. May post another question later.

EMoe