Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox & String
How do I get a MsgBox to display the value of a string
rather then the string name? i.e. Dim sName As String, sDate As String sName = (Left(Range("B1"), 4)) sDate = "" & Format(DateSerial(Year(Date), Month (Date) - 1, 1), " mmm yy ") MsgBox "C:\Documents and Settings\Ron Bowman\My Documents\& sName & sDate & EOM INFO\DATA INPUT." End Sub and I get "C:\Documents and Settings\Ron Bowman\My Documents\& sName & sDate & EOM INFO\DATA INPUT." I do not get the values of sName or sDate. What am I doing wrong? Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
counting the number of instances of a string within another string | Excel Worksheet Functions | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
Can I create a msgbox that is asking for a string to be typed in? | Excel Programming | |||
Create a formula into a String then assign string to a cell | Excel Programming |