ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Variable in MsgBox? (https://www.excelbanter.com/excel-programming/348275-variable-msgbox.html)

Rowan Drummond[_3_]

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?



TheIrishThug

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


TheIrishThug[_2_]

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