How to get text and a variable in a messagebox

Question

I just need to know how to have plain text and a variable in a messagebox   For example   I can do this  MsgBox variable   And I can do this  MsgBox  Variable       But I can t do this  MsgBox  Variable       variable

User · Answer

Why not use   Dim msg as String   String Format  Variable    0    variable    More info on String Format

User · Answer

I wanto to display the count of rows in the excel sheet after the filter option has been applied  So I declared the count of last rows as a variable that can be added to the Msgbox Sub lastrowcall   Dim hm As Worksheet Dim dm As Worksheet Set dm   ActiveWorkbook Sheets  quot datecopy quot   Set hm   ActiveWorkbook Sheets  quot Home quot   Dim lngStart As String  lngEnd As String lngStart   hm Range  quot E23 quot   Value lngEnd   hm Range  quot E25 quot   Value Dim last row As String last row   dm Cells Rows Count  1  End xlUp  Row  MsgBox   quot Number of test results between the selected dates  quot    lngStart    quot   and  quot    lngEnd    quot  are  quot    last row    quot   Please Select Yes to continue  Analysis quot     End Sub

User · Answer

I kind of run into the same issue  I wanted my message box to display the message and the vendorcontractexpiration  This is what I did   Dim ab As String Dim cd As String  ab    THE CONTRACT FOR THIS VENDOR WILL EXPIRE ON   cd   VendorContractExpiration   If InvoiceDate  gt   VendorContractExpiration - 120 And InvoiceDate  lt  VendorContractExpiration Then  MsgBox  ab   amp   cd   vbCritical   WARNING   End If

User · Answer

As has been suggested  using the string format method is nice and simple and very readable   In vb net the       is used for addition and the    amp    is used for string concatenation   In your example   MsgBox  Variable       variable    becomes   MsgBox  Variable      amp  variable    I may have been a bit quick answering this as it appears these operators can both be used for concatenation  but recommended use is the   amp    source http   msdn microsoft com en-us library te2585xw v VS 100  aspx  maybe call  variable ToString     update   Use string interpolation  vs2015 onwards I believe    MsgBox   Variable    variable

User · Answer

MsgBox  Variable  0      variable

[vb.net] How to get text and a variable in a messagebox

Examples related to vb.net

Examples related to messagebox