CODEWITHSUNDEEP
vbaexcel
Mdaox
Mdaox

Reputation: 81

How can I make the value of a textbox mulitiple srtings from multiple cells?

How can I format this correctly. I might be really confused but I just can't remember how I had done this in the past.

FndRng.Offset(0, 10).Value = cboStatus.Value&" "&txtDateOfDeparture.Value&" "&through&" "&txtDateOfReturn

Thank you!

Upvotes: 0

Views: 21

Answers (2)

Krystian Kozłowski
Krystian Kozłowski

Reputation: 162

You miss spaces

FndRng.Offset(0, 10).Value = cboStatus.Value & " " & txtDateOfDeparture.Value & " " & through & " " & txtDateOfReturn

Upvotes: 1

Scott Craner
Scott Craner

Reputation: 152585

Put space between & and anything else:

FndRng.Offset(0, 10).Value = cboStatus.Value & " " & txtDateOfDeparture.Value & " " & through & " " & txtDateOfReturn

Upvotes: 2

Related Questions