Simple programming question

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
 
T

Tom Ogilvy

With a formula:
=A1 & ", " & B1 & ", " & C1

or in code

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

Range("B9").Value = sStr
 
A

abxy

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
 
Top