VBA String concatenation

Question

Is there any Java-like solution for concatenatin strings in VBA?

I want to use a MsgBox in a way like this:

...
Set UT = Workbooks(dropdownValue).Worksheets(1)
With UT
       UT_rows = .Cells(3, 15).End(xlDown).Row
End With
MsgBox "Rows of the file: " + UT_rows

But when I do that, my code hangs up at this point. (incompatible Types)

The code is fine. I believe the message box appears but gets overlapped by other (top-level?) windows. Otherwise please provide more details about how this code is called and what is variable. — GSerg
– GSerg, Commented Jul 15, 2010 at 9:25
"variable" is just a value, which was read out from an Excel (2003) cell — poeschlorn
– poeschlorn, Commented Jul 15, 2010 at 9:54

Alex K. · Accepted Answer · 2010-07-15 12:47:19Z

12

You should always use & when concatenating;

MsgBox "Rows of the file: " & UT_rows

answered Jul 15, 2010 at 12:47

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

poeschlorn Over a year ago

Thanks, this was the point :) Coming from java I've never thought about this...thanks a lot

Collectives™ on Stack Overflow

VBA String concatenation

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related