Simple programming question

  • Thread starter Thread starter abxy
  • Start date Start date
A

abxy

I'm in the middle of creating a UserForm, but this question is les
about the UserForm and more about just simple programming I suppose...
Ok, I have 3 cells, one with the City, one with the State, and one wit
the Zip code.

...I want to have another cell to display display the values of all
of those cells in a "City, State, Zip" format. How do I do this
 
With a formula:
=A1 & ", " & B1 & ", " & C1

or in code

sStr = Range("A1").Value & ", " & Range("B1").Value & ", " &
Range("C1").Value

Range("B9").Value = sStr
 
Thankyou, Thankyou, and Thankyou more!

Oh my goodness, the answer was so simple, I don't know why tha
solution didn't occur to me.

Anyhoo, Thanks a lot for the help, and for giving the answer in ,both
worksheet and VBA format. I'm sure I won't be the only one to get us
out of this thread, someone will sure enough come along later on wit
the same question, and all they'll have to do is reference thi
thread.

Thanks
 
Back
Top