PDA

View Full Version : Solved: Place a comma in between two words



av8tordude
05-10-2010, 01:48 PM
I have 2 combo boxes in a userform. The code below works fine, except i can not figure out a way to enter a comma in between the two words when it enters them into a cell.

Example... If cboCity= Raleigh & cboState = North Carolina, the code enters "RaleighNorth Carolina". I would like it to enter "Raleigh, North Carolina". Can anyone assist. Thank you


.Cells(Cur_Row, "H") = Me.cboCity & Me.cboState

Aussiebear
05-10-2010, 01:52 PM
Try

.Cells(Cur_Row, "H") = Me.cboCity & "," & Me.cboState

av8tordude
05-10-2010, 01:54 PM
Try

.Cells(Cur_Row, "H") = Me.cboCity & "," & Me.cboState

Aussie...Thank you soo much. Just as I posted my request, i went back to try that and it work....lol. When I came back you beat me to the punch...lol Thank you anyways...I really appreciated.