VBA Referencing a cell

  • Thread starter Thread starter EMoe
  • Start date Start date
E

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
 
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...
 
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
 
Thanks for the reply. I'm still analyzing the codes. May post another
question later.

EMoe
 
Back
Top