Using a Variable in a VBA Message Box

TechKnowledge Content

Question:

Can a variable be used in a VBA message box?


Answer:

Yes, a variable can be used in a VBA message box. Below is an example of using a variable in a message box.


Private Sub Field_BeforeLostFocus(KeepFocus As Boolean, CancelLogic As Boolean)


Dim Var1 As String


Var1 = VendorID

MsgBox "The variable is " + Var1


End Sub


In this example, the VendorID from the window is being set as the variable. The variable is being called Var1. When the message box is displayed, the message will read "The variable is XXXX" where XXXX is the VendorID from the window. If ACETRAVE0001 was the vendor on the window, the message box would read "The variable is ACETRAVE0001".




This article was TechKnowledge Document ID:24404

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×