![]() |
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? |
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 |
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 |
All times are GMT +1. The time now is 05:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com