Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Referencing a cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Referencing a cell
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Referencing a cell
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 , 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Referencing a cell
Thanks for the reply. I'm still analyzing the codes. May post another question later. EMoe -- EMoe ------------------------------------------------------------------------ EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183 View this thread: http://www.excelforum.com/showthread...hreadid=498074 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a Cell | Excel Worksheet Functions | |||
cell referencing | Excel Worksheet Functions | |||
Referencing Cell Next To Today's Date Cell | Excel Discussion (Misc queries) | |||
referencing a cell | Excel Worksheet Functions | |||
referencing a name from a cell value | Excel Discussion (Misc queries) |