Simple programming question
 

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

--
Message posted from http://www.ExcelForum.com

Simple programming question
 

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

or in code

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

Range("B9").Value = sStr

--
Regards,
Tom Ogilvy

"abxy " wrote in message
...
I'm in the middle of creating a UserForm, but this question is less
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 with
the Zip code.

..I want to have another cell to display display the values of all 3
of those cells in a "City, State, Zip" format. How do I do this?


---
Message posted from http://www.ExcelForum.com/

Simple programming question
 

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

--
Message posted from http://www.ExcelForum.com