Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in MsgBox?
Try:
Dim strVar As String strVar = "The Value" MsgBox "error:" & Chr(10) & "non-match of " & strVar Hope this helps Rowan TheIrishThug wrote: i want to display an error messages in a msgbox that says "error: non-match of [the value of the variable that i was testing]." i can do text or the variable value if they r on their own, but not as one box. can anyone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in MsgBox?
i want to display an error messages in a msgbox that says "error: non-match of [the value of the variable that i was testing]." i can do text or the variable value if they r on their own, but not as one box. can anyone help? -- TheIrishThug ------------------------------------------------------------------------ TheIrishThug's Profile: http://www.excelforum.com/member.php...o&userid=29682 View this thread: http://www.excelforum.com/showthread...hreadid=494035 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in MsgBox?
thank u, works -- TheIrishThug ------------------------------------------------------------------------ TheIrishThug's Profile: http://www.excelforum.com/member.php...o&userid=29682 View this thread: http://www.excelforum.com/showthread...hreadid=494035 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
setting a range variable equal to the value of a string variable | Excel Programming | |||
Excel VBA - MsgBox to display variable value? | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming |